Show TOC

Setting SQL Server Startup OptionsLocate this document in the navigation structure

Use

When the SQL Server is started, parameters are read from the Windows registry that influence how it is started. In the course of your administrative work, you may need to modify or check these parameters using the SQL Server Configuration Manager.

Procedure

  1. In the SQL Server Configuration Manager, select the SQL Server (MSSQLSERVER) service and choose Action → Properties.

    The Server Properties dialog box opens.

  2. On the Advanced tab, choose Startup Parameters.
  3. To add a parameter, open the Startup Parameters line and add the new parameter separated with ";" .

To get information about available parameters, search for sqlservr application in the MS SQL Server Books Online.

Note

In the Registry, the parameters are located in:

HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/MSSQL.<x>/MSSQLServer/parameters/