Change SQL Server service account password

Table of Contents

Issue #

You have lost the password of any of the SQL Server service accounts. Or you simply need to change it.

Resolution #

Follow the steps below in order to change the password used by the SQL Server (Database Engine) service:

  1. Click the Start button, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click SQL Server Configuration Manager.
  2. In SQL Server Configuration Manager, click SQL Server Services.
  3. In the details pane, right-click SQL Server (), and then click Properties.
  4. In the SQL Server () Properties dialog box, on the Log On tab, for the account listed in the Account Name box, type the new password in the Password and Confirm Password boxes, and then click OK.

The password takes effect immediately, without restarting SQL Server.

References #

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/scm-services-change-the-password-of-the-accounts-used?view=sql-server-ver15

Powered by BetterDocs