As you know, to access the control panel of Database you have to connect to the SQL Server of that Database. And the SQL Service must always remain silent to communicate with the connection. But somethime, when installing or using Service is accidentally disabled, it causes connection error that you see is A-network-related or …

As I mentioned above, this error is caused by Service SQL Server being shut down. The solution is to start Service SQL Server. And the following steps will help you make.

How to recover a SQL Server connection

SQL Server services are managed separately in Sql Server Configuration. On Win 7 you can find it in Start, but on Windows 10 you need to use the following path to find Sql Server Configuration in the correct SQL version.

SQL Server 2017C:\Windows\SysWOW64\SQLServerManager14.msc
SQL Server 2016C:\Windows\SysWOW64\SQLServerManager13.msc
SQL Server 2014 (12.x)C:\Windows\SysWOW64\SQLServerManager12.msc
SQL Server 2012 (11.x)C:\Windows\SysWOW64\SQLServerManager11.msc

Access to Sql Server Configuration, as you see Service SQL Server is in a Stopped state. This means that your SQL Server is not running to listen for the connection pointed to.

Then right-click and select Start to recover SQL Server connection.

Finished, you can try to reconnect.

Also, if SQL Server is set to Start Mode as Manual, this means that every time you use it you must start the SQL Server Service. So, if you want this service to always run with Windows, go to the Windows Service to customize the SQL Server startup type to Automatic.

Just simple as that. Hope it is useful to you.

Recent Post

Leave a comment

Your email address will not be published. Required fields are marked *