title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |||
---|---|---|---|---|---|---|---|---|---|---|---|
Change the service startup account (SQL Server Configuration Manager) |
Learn how to change the service accounts that SQL Server and many of its services use. View limitations and restrictions on changes in service accounts. |
rwestMSFT |
randolphwest |
07/26/2024 |
sql |
configuration |
conceptual |
|
[!INCLUDE SQL Server]
This article describes how to use SQL Server Configuration Manager to change the startup options of [!INCLUDE ssNoVersion] services and to change the service accounts that are used by the [!INCLUDE ssDEnoversion], [!INCLUDE ssNoVersion] Agent, [!INCLUDE ssNoVersion] Browser, [!INCLUDE ssNoVersion] [!INCLUDE ssASnoversion], and [!INCLUDE ssNoVersion] [!INCLUDE ssISnoversion] with [!INCLUDE ssManStudioFull], [!INCLUDE tsql], 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 [!INCLUDE ssDE] and [!INCLUDE ssNoVersion] Agent, the [!INCLUDE ssNoVersion] service (the [!INCLUDE ssDE]) must be restarted for the change to take effect. When the service is restarted, all databases associated with that instance of [!INCLUDE ssNoVersion] will be unavailable until the service successfully restarts. If you have to change the service startup account of [!INCLUDE ssNoVersion] or [!INCLUDE ssNoVersion] Agent, make sure that you do so during regularly scheduled maintenance or when the databases can be taken offline without interrupting daily operations.
-
Clustered servers
Changing the service account that is used by [!INCLUDE ssNoVersion] or [!INCLUDE ssNoVersion] Agent must be performed from the active node of the [!INCLUDE ssNoVersion] cluster.
When you run on [!INCLUDE winserver2008-md] (in a non-default configuration using Domain groups), changing the service account that is used by [!INCLUDE ssNoVersion] or [!INCLUDE ssNoVersion] Agent requires SQL Server Configuration Manager to stop [!INCLUDE ssNoVersion] by taking the resource groups offline.
-
SKU Upgrade ([!INCLUDE ssExpress] to non-Express SKU)
During [!INCLUDE ssExpress] installation, the [!INCLUDE ssNoVersion] Agent service is configured to use the Network Service account but disabled. SQL Server Configuration Manager can change the account assigned for the [!INCLUDE ssNoVersion] Agent service but the service can't be enabled or started. After SKU upgrade from [!INCLUDE ssExpress] to non-Express, the [!INCLUDE ssNoVersion] Agent service isn't automatically enabled, but can be enabled when needed by using the SQL Server Configuration Manager and changing the service start mode to Manual or Automatic.
-
On the Start menu, point to All Programs, point to [!INCLUDE ssnoversion], point to Configuration Tools, and then select SQL Server Configuration Manager.
Because SQL Server Configuration Manager is a snap-in for the [!INCLUDE msconame-md] Management Console program and not a stand-alone program, SQL Server Configuration Manager doesn't appear as an application in newer versions of Windows.
Operating system Details Windows 10 and Windows 11 To open SQL Server Configuration Manager, on the Start Page, type SQLServerManager16.msc
(for [!INCLUDE sssql22-md]). For other versions of [!INCLUDE ssNoVersion], replace16
with the appropriate number. SelectingSQLServerManager16.msc
opens the Configuration Manager. To pin the Configuration Manager to the Start Page or Task Bar, right-clickSQLServerManager16.msc
, and then select Open file location. In the Windows File Explorer, right-clickSQLServerManager16.msc
, and then select Pin to Start or Pin to taskbar.Windows 8 To open SQL Server Configuration Manager, in the Search charm, under Apps, type SQLServerManager<version>.msc
, such asSQLServerManager16.msc
, and then press Enter. -
In SQL Server Configuration Manager, select SQL Server Services.
-
In the details pane, right-click the name of the [!INCLUDE ssNoVersion] instance for which you want to change the service startup account, and then select Properties.
-
In the SQL Server <instancename> Properties dialog box, select the Log On tab, and select a Log on as account type.
-
After selecting the new service startup account, select OK.
A message box asks whether you want to restart the [!INCLUDE ssNoVersion] service.
-
Select Yes, and then close SQL Server Configuration Manager.