Computer Science Era

Advertisement

Saturday, 22 February 2014

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)

The system cannot find the file specified.

Erro 40: Cannot Connect to SQL Server


1st Step: Go to SQL Server Configuration Manager

sql-server-configuration-manager

2nd Step: Click on SQL Server Services

SQL Server Services

3rd Step: Right Click on SQL Server (MSSQLSERVER)

SQL Server (MSSQLSERVER)

4th Step: Click on Properties

Properties

5th step: Goto Service and Change Start Mode from Manual/Disabled to Automatic

Start Mode from Manual/Disabled to Automatic

6th step: Goto to Log On and Click on Start Button and do the same for all

Goto to Log On and Click on Start Button

7th Step: Click Apply and OK

8th Step: Got SQL Server Management Studio and Click on Connect

SQL Server Management Studio

9th Step: SQL Server Management Studio is now working correctly

SQL Server Management Studio Connected

0 comments:

Post a Comment