MS SQL cannot connect to server

Asked By 60 points N/A Posted on -

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)

Answered By 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

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.


Login/Register to Answer

Related Questions