Skip to content

Enabling MSSQL Server Autostart

Prerequisites§

  • Start SQL Server Configuration Client (SSCC) on the MSSQL host.

Procedure§

  1. In the SSCC, in its left pane, expand SQL Server Configuration Manager (Local), and then click SQL Server Services.

  2. Activate the SQL service autostart:

    1. In the right pane, right click SQL Server, and from the action menu select Stop.

    2. Right click SQL Server again, and from the action menu select Properties.
      The properties window appears.

    3. In the window that appears, go to the Service tab.

    4. On the tab, from the Start Mode list, select Automatic.
    5. In the window, click ОК to apply changes and close the window.
    6. In the right pane of SSCM, right click SQL Server, and from the action menu select Start.

  3. Repeat the previous step for SQL server browser.

See Also§