SQL Server does not start after changing the computer password

  • Article

You will receive the following error when you change your computer password if you install SQL Server and SQL Server Agent using the account on the computer on which you installed Commerce Server 2002:

Could not start the <Server name> Service on Local Computer.

Error 1069: The service did not start due to a logon failure.

Solution

You must change the SQL Server login password for the MSSQLServer and SQLServerAgent services for your account.

To change the SQL Server login password

  1. Click Start, point to Programs, point to Administrative Tools, and then click Services.
  2. In the Services screen, right-click the MSSQLSERVER service, and then select Properties.
  3. In the MSSQLSERVER Properties (Local Computer) dialog box, on the Log On tab, do the following:
    Use this To do this
    This account Type the name of the account for which you assigned the new password.
    Password Type the new password for the MSSQLSERVER service to use.
    Confirm password Type the new password again for the MSSQLSERVER service.
  4. Click OK.

To change the SQL Server Agent login password

  1. Click Start, point to Programs, point to Administrative Tools, and then click Services.
  2. In the Services screen, right-click the SQLSERVERAGENT service, and then click Properties.
  3. In the SQLSERVERAGENT Properties (Local Computer) dialog box, on the Log On tab, do the following:
    Use this To do this
    This account Type the name of the account for which you assigned the new password.
    Password Type the new password for the SQLSERVERAGENT service to use.
    Confirm password Type the new password again for the SQLSERVERAGENT service.
  4. Click OK.

Copyright © 2005 Microsoft Corporation.
All rights reserved.