Server Components

Besides the server Net-Libraries, there are several main server components (services) to Microsoft® SQL Server™:

• Open Data Services
• SQL Server (MSSQLServer service)
• SQL Server Agent (SQLServerAgent service)
• Microsoft Search service
• Microsoft Distributed Transaction Coordinator (MS DTC service)

When SQL Server is running on Microsoft Windows NT®, SQL Server, SQL Server Agent, and MS DTC are implemented as Windows NT services. On Microsoft Windows® 95/98, the server components are not implemented as services because the operating system does not support services. The Microsoft Search Service is only available on Windows NT Server or Windows NT Enterprise Edition, not on Windows NT Workstation or Windows 95/98.

The server components can be stopped and started several ways:

• Windows NT can start each service automatically when the operating system is starting.
• Use SQL Server Service Control Manager to start or stop the service.
• Use SQL Server Enterprise Manager to start or stop the service.
• On Windows NT, use the net start and net stop command prompt commands to stop or start each service.

Open Data Services is not started or stopped on its own; it starts or stops when SQL Server stops or starts.