Home > Resources > SQL Server > Operate SQL Server Services

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

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:

Hot Categories
Windows Password
Product Key Finder
SQL Password
More +
Hot Articles
4 Ways to Change SQL Server SA Password
SQL Server 2012 SA Password Reset
How to Login SQL Server after SA Account Locked Out
How to Change Server Authentication Mode in SQL Server
How to Enable Mixed Mode Authentication for SQL Server
More +
Latest Articles
How to Correct SQL Login Failed Error after SA Password Forgot
Solve SQL Server Connection Error 26
How to Fix Login Failed to SQL Server
More +
Hot Products
Windows Password Genius
iTunes Password Genius
Product Key Finder
More +