SQL Server - Services

Introduction

MS SQL Server provides the two Services given below which are mandatory for database creation and maintenance. Other add-on Services available for different purposes are also listed.

  • SQL Server.
  • SQL Server Agent.

Other Services

  •  SQL Server Browser.
  •  SQL Server Full Text Search.
  •  SQL Server Integration Services.
  •  SQL Server Reporting Services.
  •  SQL Server Analysis Services.

The Services given above can be availed, using the method given below.

Start Services

To start any Service, either of the following two methods can be used.

Method 1

Services.msc

Step 1

Go to Run, type services.msc and click OK. The screen given below appears.

 

Step 2

To start the Service, right-click on Service, click Start button. The Services will start, as shown below.

 

Method 2

SQL Server Configuration Manager

Step 1

Open Configuration Manager, using the process given below.

Start -> All Programs -> MS SQL Server 2012 -> Configuration Tools -> SQL Server configuration manager.

 

Step 2

Select the Service name, right-click and click Start option. The Services will start, as shown below.

 

Stop Services

To stop any Service, any of the following three methods can be used.

Method 1

Services.msc

Step 1

Go to Run, type services.msc and click OK. The screen given below appears.

 

Step 2

To stop Services, right-click on Service and click Stop. The selected Service will be stopped, as shown below.

 

Method 2

SQL Server Configuration Manager

Step 1

Open Configuration Manager, using the process given below.

Start -> All Programs -> MS SQL Server 2012 -> Configuration Tools -> SQL Server configuration manager.



Step 2

Select the Service name, right-click and click Stop option. The selected Service will be stopped, as shown below.

 

Method 3

SSMS (SQL Server Management Studio)
 
Step 1

Connect to the instance, as shown below.

 

Step 2

Right-click on the instance name and click Stop option. The screen given below appears.

 

Step 3

Click Yes button and the screen given below will open.

 

Step 4

Click Yes option on the screen given above to stop SQL Server agent Service. The Services will be stopped, as shown below.

 

Note
  •  We cannot use SQL Server Management Studio method to start the Services as we are unable to connect due to the Services , which are already in stopped state.

  •  We cannot exclude stopping SQL Service agent service while stopping SQL Server Service as SQL Server Agent Service is a dependent Service.