Wednesday, June 8, 2016

Different ways to start and stop Microsoft Sql Server services

Sometimes it happens that we are unable to connect sql server through Sql Server Management Studio or our application is not connecting to database This might occur because Sql Server services are stopped at our machine. Sometimes we also in need to restart the services to opitimize the PC.

There are multiple ways to start/stop sql server services Like-

Start - All Programs Menu

Navigate to All Programs - Microsoft Sql Server [version] - Configuration Tools - Sql Server Configuration Manager and start/stop the respective sql server services.

Start/Stop sql server through Sql Server Management Studio

Connect Sql server through Sql Server Management Studio and right click sql instance and select start/stop/restart/pause etc.

Start/Stop sql server through command

Type "SQLServerManager[version].msc" on windows search or in Run command, Then press enter to open Sql Server Configuration Manager. Start/Stop the respective service as per your need.

Note :- SQLServerManager12.msc is for Sql Server 2014 and SQLServerManager13.msc is for Sql Server 2016. You can change the version as per the Sql Server version installed on your PC.

About the Author

Manish Rai

Author & Editor

I am Manish Rai an IT Professional, I started the at the beginning of 2013.My goal is to establish as a information portal that will help every individual(s) to get the information related to their day by day activities and use this information for the good purpose. I love to share my knowledge with the people. Follow me on Facebook | Google+ | Twitter


Post a Comment

Copyright © . All Rights Reserved