SQL Server  «Prev 

Automatically invoking services in Windows

There are two ways that you can ensure each service starts automatically when the system is booted:
  1. Select the check box at the bottom of SQL Server Service Manager dialog that reads Auto-start service when OS starts.
  2. If you are running Windows, bring up the Services dialog box. Here's how:
    1. Select Start>>Settings>>Control Panel
    2. Double-click the services icon to bring up the Serices dialog box, as shown in the figure below:

Services Dialog box
Services Dialog box
  1. Double-click the desired service.
  2. Select Automatic from the Type drop-down list in the Startup section, if it is not already selected.
  3. Repeat steps 3 and 4 for the other two services.
  4. You may be required to reboot your server.