How to start SQL Server (Service Manager)

To start SQL Server

1. If the service is a remote service, enter the name of the remote server in the Server box.

   This connects you to the remote server and populates the Services box with the names of Microsoft® SQL Server™ services registered on the remote computer.

2. In the Services box, click MSSQLServer.

   The current state of the service is indicated by the light on the traffic signal and by the message in the status bar.

3. Click Start/Continue.

   SQL Server starts as a service under the Windows NT Service Control Manager using the default startup options written to the Microsoft Windows NT® Registry by SQL Server Setup.

See Also

Starting SQL Server Manually