Starting the SQL Server automatically

You can automatically start the SQL server by using the SQL Server Configuration Manager.

Procedure

  1. From the Windows Start menu, open SQL Server NNNN Configuration Manager, where NNNN is the version of your SQL Server.
  2. Click SQL Server Services in the left pane. In the right pane, a number of entries are displayed.
  3. Right-click on SQL Server (MSSQLSERVER) and choose Properties from the pop-up menu that appears.
  4. A window is displayed with different tabs.
  5. Click the Log On tab.
  6. Check the Service Status (just above the buttons Start, Stop, Pause, Restart). If the Service Status is not running, click the Start button. This starts the SQL Server.
  7. Click the Service tab.
  8. Check the entry Start Mode. This should be set to Automatic. If not, change the setting to Automatic.
  9. Click OK. SQL Server starts automatically when the windows starts.
  10. Close SQL Server Configuration Manager.