MS SQL cannot connect to server

Asked By Jaycelin Nimbus 60 points N/A Posted on - 08/23/2012

All of a sudden I cannot connect anymore to the server, never had this kind of problem, did some research and read that it has something to do with the tcp/ip protocol but  it is already enabled. any other things that I need to configure?

 

Connect to Server

Cannot connect to (local)

Additional Information:

A network-related or instance-specific error occurred while establishing a connection to SQL Server.

The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured

to allow remote connections. (provider: Named Pipes Provider, error: 40-

Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

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

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

Answered By Manhathen Den 5 points N/A #146842

MS SQL cannot connect to server

The error simply saying that the SQL Server is not accessible and the possible reason might be the configuration of the server connection. To check that go to Start > All Programs > Microsoft SQL Server > Configuration Tools > SQL Server Configuration Manager then you need to verify protocol is properly configured for more information about that check this https://technet.microsoft.com/en-us/library/ms187892.aspx

Some other issue is about the Service Account Authentication; Check if the SQL Server service is running if not, start it. You need to make sure also that the account is not locked out. Check the account credential if the configuration is OK. Good luck.

 

About Manhathen Den

Questions
1

Answers
151

Best Answers
24

• Vote Up 0 Vote Down

• Posted on - 08/29/2012
• Question Category: MS SQL Server