logo
Resources SQL Server Operate SQL Server Services

How to Start/Stop/Pause/Restart SQL Server Service

By Hally  | Last Updated

SQL Server Service controls the SQL Server running. If we want to run SQL Server successfully, we have to manage SQL Server service properly. And SQL Server configuration tool provides us a way to do this. Just open SQL Server Configuration Manager, we could start, stop, pause or restart SQL Server Service.

Steps to start, stop, pause or restart SQL Server Service:

Step 1: On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.

open SQL Server Configuration Manager

Step 2: In SQL Server Configuration Manager, expand Services.

Step 3: In the results pane, select any instance of SQL Server such as SQL Server (SQLEXPRESS).

operate SQL Server Service

Now, we have two choices to operate SQL Server Service.

1. Right-click any instance of SQL Server such as SQL Server (SQLEXPRESS), and then click Stop, Pause, Start or Restart.

2. There are four kinds of buttons on toolbar, meaning Start, Pause, Stop and Restart. Click one of them to operate SQL Server Service according to your will.

But please pay attention to followings:
1. Please stop SQL Server Service before reset or change forgotten SQL password with SQL Password Genius.
2. Please start SQL Server Service before you run SQL Server Management Studio to operate SQL database.

 

Related Articles: