SQL Server Service Manager

Note that this tutorial uses the 2000 edition of SQL Server (SQL Server 2000).

For the latest version, see SQL Server tutorial.

SQL Server Service Manager is used to start, stop, and pause the various components on SQL Server. These components run as Windows services.

The following services can be stopped/started/paused via the SQL Service Manager:

ServiceDescription
SQL Server serviceImplements the SQL Server database engine. There is one SQL Server service for each instance of SQL Server running on the computer.
SQL Server Agent serviceImplements the agent that runs SQL Agent jobs and alerts. There's one SQL Agent service for each instance of SQL Server running on the computer.
Microsoft Search serviceImplements the full-text search engine. There is only one full-text search engine regardless of how many instances of SQL Server are running on the computer.
MSDTC serviceManages distributed transactions. There is only one MSDTC service regardless of how many instances of SQL Server are running on the computer.
MSSQLServerOlAPService serviceImplements the SQL Server Analysis Services. There is only one MSSQLServerOlAPService service regardless of how many instances of SQL Server are running on the computer.

Using the SQL Server Service Manager

SQL Server Service Manager is a taskbar application. When SQL Server Service Manager is minimized, an icon SQL Server Service Manager icon appears in the taskbar.

To use the Service Manager, you can either right click on the icon, or double click on the icon. Right clicking provides a menu of options, double clicking maximizes the Service Manager for you to select your options.

SQL Server Service Manager - maximized