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 www.einfoportal.com at the beginning of 2013.My goal is to establish www.einfoportal.com 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

1 comments:

  1. This is also a very good post which I really enjoyed reading. It is not everyday that I have the possibility to see something

    temple run 2 |  bloons tower defense 5 |  tank trouble | happy wheels 3

    ReplyDelete

 
Copyright © www.einfoportal.com . All Rights Reserved