Microsoft SQL Server cannot connect to BKKSQL020

Asked By joseph warnerr 0 points N/A Posted on - 10/15/2013

Hi,

While opening a connection to Microsoft SQL Server I get an error as shown below. I am new to computing so I would like all suggestions that will help me figure out the source of the error.

Cannot connect to BKKSQL020SQLEXPRESS

Additional information

Login failed for user ‘sa’ (Microsoft SQL Server, Error: 18456)

• Status: Open
• Question Views: 638
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Abbey Edward 0 points N/A #176764

Microsoft SQL Server cannot connect to BKKSQL020

Use the following steps to resolve your issue

·         Check if the server is responding by ping command

·         Check the configuration of the firewall

·         The  TCP port or the pipeline has to be specified in the connection string

·         Check whether SQL Server Browser Services are enabled.

·         Check if the port UDP 1434 is open in the firewall

·         Check if you are using the correct username and password

About Abbey Edward

Questions
0

Answers
24

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 10/19/2013
• Question Category: MS SQL Server