How to start and stop services in MS SQL Server

MS SQL Server brings two main services for creating and maintaining databases (CSDL). There are also additional services for other purposes.

The two main services of MS SQL Server include:

1. SQL Server
2. SQL Server Agent

Additional services of MS SQL Server include:

1. SQL Server Browser
2. SQL Server FulL Text Search
3. SQL Server Integration Services
4. SQL Server Reporting Services
5. SQL Server Analysis Services

You can start or suspend the use of the above services by the way below.

Start the service in MS SQL Server

To start any service in MS SQL Server, you can use 1 of 2 ways below.

Method 1: Use Services.msc

Step 1 : Go to the Run dialog box , type services.msc and click OK. The screen below will appear.

Find services in Windows Run dialog box

Step 2 : To start, right-click on the service you need and select Start. Then the service will start as shown in the image below.

The selected service has been started

Method 2: Use SQL Server Configuration Manager

Step 1: Open the manager with the Start steps> All Programs > MS SQL Server 2012 > Configuration Tools > SQL Server Configuration Manager.

The service list appears when the manager is opened

Step 2: Select the service name, right click and select Start. Service starts successfully as shown below.

Successful startup of service in MS SQL Server

Stop service in MS SQL Server

To stop the service in MS SQL Server, use 1 of 3 ways.

Method 1: Use Services.msc

Step 1 : Go to the Run dialog box , type services.msc and click OK. as in Step 1 - way 1 when starting the service.

Step 2: To stop the service, right-click and select Stop. The selected service will be stopped as shown in the image below.

Method 2: Use SQL Server Configuration Manager

Step 1: Open Configuration Manager with the steps as in step 2 - way 2 when starting the service.

Step 2: Select the service to stop, right-click and select Stop. The selected service will stop.

Method 3: Use SQL Server Management Studio SSMS

Step 1: Connect to the SQL Server installation as shown below.

SQL Server TESTINSTANCE

Step 2: Right-click the name of the installation and select Stop. The screen below will appear.

Dialog box when selecting Stop installation of SQL Server

Step 3: Select Yes, the screen below will appear.

Reconfirm service suspension

Step 4: Select Yes to agree to stop the SQL Server Agent service. This service will be suspended as shown below.

The SQL Server Agent status is Disabled

Previous article: Database management in MS SQL Server

Next article: High Availability in MS SQL Server