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:

SQL Server
SQL Server Agent

Additional services of MS SQL Server include:

SQL Server Browser
SQL Server FulL Text Search
SQL Server Integration Services
SQL Server Reporting Services
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.

How to start and stop services in MS SQL Server Picture 1
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.

How to start and stop services in MS SQL Server Picture 2
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.

How to start and stop services in MS SQL Server Picture 3
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.

How to start and stop services in MS SQL Server Picture 4
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.

How to start and stop services in MS SQL Server Picture 5
SQL Server TESTINSTANCE

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

How to start and stop services in MS SQL Server Picture 6
Dialog box when selecting Stop installation of SQL Server

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

How to start and stop services in MS SQL Server Picture 7
Reconfirm service suspension

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

How to start and stop services in MS SQL Server Picture 8
The SQL Server Agent status is Disabled

Previous article: Database management in MS SQL Server

Next article: High Availability in MS SQL Server

Micah Soto

Update 25 May 2019

You should read it

May be interested

How to set up your own Git server on Linux
while you can count on globally renowned git hosting services like github, in some cases it is better to host a personal git server for enhanced privacy, customizability, and security.
7 great ideas using Raspberry Pi as a server
raspberry pi is a great solution for many computer projects, from learning programming to remote control a car to building a basic stop-motion animation studio. but do you know that raspberry pi can also be used as a server? here are some ideas for using raspberry pi as a server.
Steps to prepare for installing Windows Server 2008
with windows server 2008, this is the best time to start the installation and learn about the installation of 2008, as well as the necessary executable functions (such as roles and other features), analyze new installation options. available with 2008 as core server installation, using windows deployment services (wds) as well as other installations, upgrades or dual boot scripts.
Microsoft reminds users that Windows Server 20H2 is about to be discontinued
in fact, microsoft has planned to stop rolling out new security updates for all versions of windows server, including version 20h2, on august 9, 2022.
How to install and use IIS on Windows Server 2019
according to microsoft, web server (iis) in windows server 2019 provides a secure, easy to manage, modular, and scalable platform for reliably hosting websites, services, and applications. .
Microsoft releases updates for SQL Server 2017 and Azure data services
at the pass summit 2017 conference yesterday, microsoft announced several new improvements to sql server 2017 and azure data services.
Windows Server 2003 died after July 14
microsoft announced it would stop supporting windows server 2003 from july 14, before windows 10 officially launched two weeks.
How to install IIS in Windows Server 2012
iis or internet information services is one of the most important services in windows server 2012. it has improved features compared to previous versions.
Instructions for creating and editing reports in SQL Server Reporting Services
sql server 2005, 2008 and 2008 r2 product suite, all packaged with sql server reporting services (ssrs) - a dedicated solution for creating reports for businesses. with ssrs, users can create, schedule, post and manage various reports from various sources of original data.
How to install DNS Server on Windows Server 2019
from microsoft, the domain name system (dns) is one of the industry standard protocol sets that includes tcp / ip, along with dns client and dns server that provide name resolution services that map names to the ip addresses of computers. .