English 中文(简体)
MS SQL Server - Services
  • 时间:2024-11-03

MS SQL Server - Services


Previous Page Next Page  

MS SQL Server provides the following two services which is mandatory for databases creation and maintenance. Other add-on services available for different purposes are also psted.

    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 above services can be availed using the following method.

Start Services

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

Method 1 – Services.msc

Step 1 − Go to Run, type services.msc and cpck OK. The following screen appears.

Services

Step 2 − To start service, right-cpck on service, cpck Start button. Services will start as shown in the following snapshot.

Services

Method 2 – SQL Server Configuration Manager

Step 1 − Open configuration manager using the following process.

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

Services

Step 2 − Select the service name, right-cpck and cpck on start option. Services will start as shown in the following snapshot.

Services

Stop Services

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

Method 1 - Services.msc

Step 1 − Go to Run, type services.msc and cpck OK. The following screen appears.

Services

Step 2 − To stop services, right-cpck on service and cpck Stop. The selected service will be stopped as shown in the following snapshot.

Services

Method 2 – SQL Server Configuration Manager

Step 1 − Open configuration manager using the following process.

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

Services

Step 2 − Select the service name, right-cpck and cpck Stop option. The selected service will be stopped as shown in the following snapshot.

Services

Method 3 – SSMS (SQL Server Management Studio)

Step 1 − Connect to the instance as shown in the following snapshot.

Services

Step 2 − Right-cpck on instance name and cpck Stop option. The following screen appears.

Services

Step 3 − Cpck Yes button and the following screen will open.

Services

Step 4 − Cpck Yes option on the above screen to stop SQL Server agent service. The services will be stopped as shown in the following screenshot.

Services

Note

    We cannot use the SQL Server Management Studio method to start the Services as unable to connect due to services already stopped state.

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

Advertisements