Skip to content

scm-services-configure-server-startup-options.md

Latest commit

 

History

History
78 lines (58 loc) · 6.08 KB

scm-services-configure-server-startup-options.md

File metadata and controls

78 lines (58 loc) · 6.08 KB
title Configure Server Startup Options (SQL Server Configuration Manager) | Microsoft Docs
description Learn how to set options that the SQL Server Database Engine uses when it starts. View limitations and restrictions on making changes to startup parameters.
ms.custom
ms.date 11/23/2017
ms.prod sql
ms.prod_service high-availability
ms.reviewer
ms.technology configuration
ms.topic conceptual
helpviewer_keywords
parameters [SQL Server], startup options
SQL Server, startup options
SQL Server, startup parameters
single-user mode [SQL Server], starting in
startup options [SQL Server]
startup parameters [SQL Server]
SQL Server services, setting startup options
SQL Server services, setting startup parameters
ms.assetid 7a94643c-6460-4baf-bb31-0cb99eaf970d
author markingmyname
ms.author maghan

SCM Services - Configure Server Startup Options

[!INCLUDE SQL Server] This topic describes how to configure startup options that will be used every time the [!INCLUDEssDE] starts in [!INCLUDEssCurrent] by using [!INCLUDEssNoVersion] Configuration Manager. For a list of startup options, see Database Engine Service Startup Options.

Before You Begin

Limitations and Restrictions

[!INCLUDEssNoVersion] Configuration Manager writes startup parameters to the registry. They take effect upon the next startup of the [!INCLUDEssDE].

On a cluster, changes must be made on the active server when [!INCLUDEssNoVersion] is online, and will take effect when the [!INCLUDEssDE] is restarted. The registry update of the startup options on the other node will occur upon the next failover.

Security

Permissions

Configuring server startup options is restricted to users who can change the related entries in the registry. This includes the following users.

  • Members of the local administrators group.

  • The domain account that is used by [!INCLUDEssNoVersion], if the [!INCLUDEssDE] is configured to run under a domain account.

Using SQL Server Configuration Manager

To configure startup options

  1. Click the Start button, point to All Programs, point to [!INCLUDEssCurrentUI], point to Configuration Tools, and then click SQL Server Configuration Manager.

    [!NOTE]
    Because [!INCLUDEssNoVersion] Configuration Manager is a snap-in for the [!INCLUDEmsCoName] Management Console program and not a stand-alone program, [!INCLUDEssNoVersion] Configuration Manager does not appear as an application in newer versions of Windows.

    • Windows 10:
      To open [!INCLUDEssNoVersion] Configuration Manager, on the Start Page, type SQLServerManager13.msc (for [!INCLUDEssSQL15]). For previous versions of [!INCLUDEssNoVersion] replace 13 with a smaller number. Clicking SQLServerManager13.msc opens the Configuration Manager. To pin the Configuration Manager to the Start Page or Task Bar, right-click SQLServerManager13.msc, and then click Open file location. In the Windows File Explorer, right-click SQLServerManager13.msc, and then click Pin to Start or Pin to taskbar.
    • Windows 8:
      To open [!INCLUDEssNoVersion] Configuration Manager, in the Search charm, under Apps, type SQLServerManager<version>.msc such as SQLServerManager13.msc, and then press Enter.

  2. In [!INCLUDEssNoVersion] Configuration Manager, click SQL Server Services.

  3. In the right pane, right-click SQL Server (<instance_name>), and then click Properties.

  4. On the Startup Parameters tab, in the Specify a startup parameter box, type the parameter, and then click Add.

    For example, to start in single-user mode, type -m in the Specify a startup parameter box and then click Add. (When you restart [!INCLUDEssNoVersion] in single-user mode, stop the [!INCLUDEssNoVersion] Agent. Otherwise, [!INCLUDEssNoVersion] Agent might connect first and prevent you from connecting as a second user.)

  5. [!INCLUDEclickOK]

  6. Restart the [!INCLUDEssDE].

    [!WARNING]
    After you are finished using single-user mode, in the Startup Parameters box, select the -m parameter in the Existing Parameters box, and then click Remove. Restart the [!INCLUDEssDE] to restore [!INCLUDEssNoVersion] to the typical multi-user mode.

See Also

Start SQL Server in Single-User Mode
Connect to SQL Server When System Administrators Are Locked Out
Start, Stop, or Pause the SQL Server Agent Service
Database Engine Service Startup Options