Sunday, 3 July 2016

How to resolve the connection error in SQL server ?

"Network related or instance specific error occurred while establishing a connection to the SQL server".

I believe that most of the developers faced the following issue while connecting the SQL server.



To resolve the above error please follow the below steps.

Go to SQL server configuration manager using Start -- > SQL server configuration Manager.
After opening the Configuration manager, select the SQL server instance as shown below.

You can see that the SQL service has been stopped and this is the root cause for the error.Right click the instance and select Start option.


Now the SQL service is preparing to start as shown below.





Once started you can see that the SQL service is running now.



Now if you try to connect the SQL server instance the server instance will be connected successfully as shown below.




The permanent fix for the above error is to set the startup type of the SQL service instance as Automatic.So that the service will be started automatically once you logged in the system.

No comments:

Post a Comment