Starting MS SQL Server Service - Exercise

Starting the MS SQL Server Service

Objective: Start the MSSQLSERVER service.

Exercise Scoring

This exercise is worth a total of 2 points. It's auto-scored, which means all you need to do to receive credit for having completed it is click the Submit button below.

Instructions

Follow these steps to start the MSSQLSERVER (the SQL Server Database Engine), SQLSERVERAGENT, MSDTC, and SQL Server Full-Text Filter Daemon Launcher services. If you have not installed full-text search support, you will not be able to start the Full-Text Filter Daemon Launcher service, but you can still start the other three.

Type
```
SQLServerManager17.msc
```
into the Windows Start menu and select it to open SQL Server Configuration Manager.
In the left pane, select SQL Server Services. The status of each service is listed in the right pane.
Right-click the service named SQL Server (MSSQLSERVER). If its status is Stopped, select Start from the shortcut menu.

Repeat the above procedure for the SQLSERVERAGENT, MSDTC, and SQL Server Full-Text Filter Daemon Launcher (if you installed full-text search support) services. When you've completed the steps, click the Submit button below to receive credit for having completed the exercise and to view a results page.