Export (0) Print
Expand All

Change passwords for SQL Server services (SharePoint Server 2013)

Published: April 23, 2013

Summary: Learn how to change passwords for the SQL Server services and SQL Server Agent service accounts by using SQL Server Configuration Manager.

Applies to:  SharePoint Server 2013 

SharePoint Server 2013 supports SQL Server 2008 R2 with Service Pack 1 (SP1) and SQL Server 2012. In both SQL Server versions, you must update the password for the services when the service account's password changes.

Important Important:

Do not change the passwords for the service accounts when a failover cluster node is offline. If you do this, you'll have to reset the password again when all nodes are back online.

In this article:

Before you begin

The SQL Server services and SQL Server Agent service can use built-in Windows service accounts. Both services can use the Local System account, known as NT AUTHORITY\System. This account has unrestricted access to all local system resources, is a member of the Windows Administrators group on the local computer, and is also a member of the SQL Server sysadmin fixed server role. Because this account is so powerful for security, we recommend that you use a Windows user account that is not a member of the Windows Administrators group.

note Note:

Because SharePoint 2013 runs as websites in IIS, administrators and users depend on the accessibility features that browsers provide. SharePoint 2013 supports the accessibility features of supported browsers. For more information, see the following resources:

Before you begin this operation, review the following information:

  • To change the service account or password that is used by SQL Server service or SQL Server Agent you must be in the active node of the SQL Server cluster.

  • When you run SQL Server on Windows Server 2008 R2, in a non-default configuration using Domain groups, and you change the service account password, you must use SQL Server Configuration Manager to stop SQL Server and take the resource groups offline.

Change the password for the SQL Server service account

Use the following procedure to change the password for the SQL Server service account.

To change the SQL Server service account password

  1. Verify that the user account that is performing this procedure is a member of the Administrators group on the computer that is running SQL Server.

    note Note:

    The account must also be the domain account that SQL Server uses if the Database Engine is configured to run under a domain account.

  2. Start the SQL Server Configuration Manager.

    • For Windows Server 2008 R2:

      • On the Start menu, point to All Programs, point to Microsoft SQL Server 2012 or Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.

    • For Windows Server 2012:

      • On the Start screen, click SQL Server Configuration Manager.

        If SQL Server Configuration Manager does not appear on the Start screen:

      • Right-click Computer, click All apps, and then click SQL Server Configuration Manager.

  3. In the navigation pane of the Configuration Manager, expand SQL Server Configuration Manager (Local), and then click SQL Server Services.

  4. In the details pane, right-click the name of the SQL Server instance for which you want to change the service account password, and then click Properties.

  5. In the SQL Server <instancename> Properties dialog box, click the Log On tab, type the new password in the Password and Confirm password boxes.

  6. After you change the password, click OK.

    A message asks whether you want to restart the SQL Server service.

  7. Click Yes, and then close SQL Server Configuration Manager.

Change the SQL Server Agent account password

Use the following procedure to change the password for the SQL Server Agent service account.

To change the SQL Server Agent account password

  1. Verify that the user account that is performing this procedure is a member of the Administrators group on the computer that is running SQL Server.

    note Note:

    The account must also be the domain account that SQL Server uses if the Database Engine is configured to run under a domain account.

  2. Start the SQL Server Configuration Manager.

    • For Windows Server 2008 R2:

      • On the Start menu, point to All Programs, point to Microsoft SQL Server 2012 or Microsoft SQL Server 2008 R2, point to Configuration Tools, and then click SQL Server Configuration Manager.

    • For Windows Server 2012:

      • On the Start screen, click SQL Server Configuration Manager.

        If SQL Server Configuration Manager does not appear on the Start screen:

      • Right-click Computer, click All apps, and then click SQL Server Configuration Manager.

  3. In the navigation pane of the Configuration Manager, expand SQL Server Configuration Manager (Local), and then click SQL Server Services.

  4. In the details pane, right-click SQL Server Agent (server_name), where server_name is the name of the SQL Server Agent instance for which you want to change the password of the service account, and then click Properties.

  5. In the SQL Server Agent <server_name> Properties dialog box, click the Log On tab, type the new password in the Password and Confirm password boxes.

  6. Click OK.

    A message asks whether you want to restart the SQL Server Agent service.

  7. Click Yes, and then close SQL Server Configuration Manager.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft