N/APosted 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)
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)
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.