1-02 starting and stopping SQL Sever services

Why to start the SQL Sever service:

1: Consequences of not starting.

The same as the same will not be linked to local.

Three types of services that start SQL Sever:

1: Background start service.

2:sql Sever Configure the administrator to start the service.

3: Start and stop the service using the command in the Run window:

Start the: net start Mssqlsever.

Stop: net stop mssqlsever.

How each of these services are started:

1: How to start the background service

The first step:

Right-click Computer Management

Step Two:

Will pop up this window, click Services and manage programs, then click Services

Step Three:

Locate Sqlsever (Mssqlsever) and right-click to start the service.

2: How to start the Sqlsever Configuration Management Park Service:

The first step:

Click Start, then locate the Sqlsever installation path, then click on the Configuration tool to open Sqlsever Configuration Manager.

Step Two:

Click Sqlsever Services, locate Sqlsever (mssqlsever), right-click to start the service.

3: Start and stop the service using the command in the Run window:

The first step:

Win+r pop up this window and hit the command.

1-02 starting and stopping SQL Sever services