Skip to content

scm-services-change-the-service-startup-account.md

Latest commit

 

History

History
69 lines (48 loc) · 7.26 KB

scm-services-change-the-service-startup-account.md

File metadata and controls

69 lines (48 loc) · 7.26 KB
title SCM Services - Change the Service Startup Account | Microsoft Docs
ms.custom
ms.date 01/06/2016
ms.prod sql
ms.prod_service high-availability
ms.reviewer
ms.technology configuration
ms.topic conceptual
helpviewer_keywords
SQL Server services, startup account changes
startup accounts [SQL Server]
changing startup accounts for services
ms.assetid d721c796-0397-46a7-901b-1a9a3c3fb385
author MikeRayMSFT
ms.author mikeray

SCM Services - Change the Service Startup Account

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] This topic describes how to Use the [!INCLUDEssNoVersion] Configuration Manager to change the start up options of [!INCLUDEssNoVersion] services and to change the service accounts that are used by the [!INCLUDEssDEnoversion], [!INCLUDEssNoVersion] Agent, [!INCLUDEssNoVersion] Browser, [!INCLUDEssNoVersion] [!INCLUDEssASnoversion], and [!INCLUDEssNoVersion] [!INCLUDEssISnoversion]. in [!INCLUDEssCurrent] by using [!INCLUDEssManStudioFull], [!INCLUDEtsql], or PowerShell. For more information about how to select an appropriate service account, see Configure Windows Service Accounts and Permissions.

Important

When you change the service startup account for the [!INCLUDEssDE] and [!INCLUDEssNoVersion] Agent, the [!INCLUDEssNoVersion] service (the [!INCLUDEssDE]) must be restarted for the change to take effect. When the service is restarted, all databases associated with that instance of [!INCLUDEssNoVersion] will be unavailable until the service successfully restarts. If you have to change the service startup account of [!INCLUDEssNoVersion] or [!INCLUDEssNoVersion] Agent, make sure that you do so during regularly scheduled maintenance or when the databases can be taken offline without interrupting daily operations.

Before You Begin

Limitations and Restrictions

  • Clustered servers

    Changing the service account that is used by [!INCLUDEssNoVersion] or [!INCLUDEssNoVersion] Agent must be performed from the active node of the [!INCLUDEssNoVersion] cluster.

    When running on Windows Server 2008 (in a non-default configuration using Domain groups), changing the service account that is used by [!INCLUDEssNoVersion] or [!INCLUDEssNoVersion] Agent requires [!INCLUDEssNoVersion] Configuration Manager to stop [!INCLUDEssNoVersion] by taking the resource groups offline.

  • SKU Upgrade ([!INCLUDEssExpress] to non-Express SKU)

    During [!INCLUDEssExpress] installation, the [!INCLUDEssNoVersion] Agent service is configured to use the Network Service account but disabled. [!INCLUDEssNoVersion] Configuration Manager can change the account assigned for the [!INCLUDEssNoVersion] Agent service but the service cannot be enabled or started. After SKU upgrade from [!INCLUDEssExpress] to non-Express, the [!INCLUDEssNoVersion] Agent service is not automatically enabled, but can be enabled when needed by using the [!INCLUDEssNoVersion] Configuration Manager and changing the service start mode to Manual or Automatic.

Using SQL Server Configuration Manager

To change the SQL Server service startup account

  1. On the Start menu, 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 details pane, right-click the name of the [!INCLUDEssNoVersion] instance for which you want to change the service startup account, and then click Properties.

  4. In the SQL Server <instancename> Properties dialog box, click the Log On tab, and select a Log on as account type.

  5. After selecting the new service startup account, click OK.

    A message box asks whether you want to restart the [!INCLUDEssNoVersion] service.

  6. Click Yes, and then close [!INCLUDEssNoVersion] Configuration Manager.

See Also

Start, Stop, Pause, Resume, Restart the Database Engine, SQL Server Agent, or SQL Server Browser Service
Configure WMI to Show Server Status in SQL Server Tools