SQL Server Management Studio can not connect

sahossaini picture sahossaini · Dec 31, 2013 · Viewed 30.8k times · Source

I have installed SQL Server Management Studio 2014. In "connect to server" window, I selected server type as "Database engine", server name as "(local)" but when I try to connect, n error is shown-

TITLE: Connect to Server

Cannot connect to ..

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)

Please help what to do...

Answer

Premchand Yelavarthi picture Premchand Yelavarthi · Dec 31, 2013

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)

This is a common error which arises when connecting to SQL Server with Management Studio.

This includes different type of error scenarios like (Service--Not Available),(Service-Not Running),(Network Library- Not Enabled),(Fire Wall-Blocking) Etc.

Please troubleshoot in systematic manner.

  1. Click On start button and type Services.MSC

  2. Check whether the SQL Server service has been installed and is running fine.

Please check the service whether started or not.

If Yes:

  • Next Scenario is Network Libraries Tune.

If No

  • Install the SQL Server Engine from the software package and start the service.