Starting the SQL Server automatically
You can automatically start the SQL server by using the SQL Server Configuration Manager.
Procedure
- From the Windows Start menu, open SQL Server NNNN Configuration Manager, where NNNN is the version of your SQL Server.
- Click SQL Server Services in the left pane. In the right pane, a number of entries are displayed.
- Right-click on SQL Server (MSSQLSERVER) and choose Properties from the pop-up menu that appears.
- A window is displayed with different tabs.
- Click the Log On tab.
- 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.
- Click the Service tab.
- Check the entry Start Mode. This should be set to Automatic. If not, change the setting to Automatic.
- Click OK. SQL Server starts automatically when the windows starts.
- Close SQL Server Configuration Manager.