Article ID: 8182, created on Mar 11, 2010, last review on May 11, 2014

  • Applies to:
  • Operations Automation 2.9

Resolution

These services are used by MS SQL, but POA does not use them at all. The procedure for changing the passwords of the SQLAgentAccount# and SQLBrowseAccount# users is described in Microsoft KB articles, so this article references those MS articles and provides only a short summary.

The procedure is as follows.

1. Change the passwords of the users in the Active Directory.


2. Use this article for MS SQL Server 2008: http://msdn.microsoft.com/en-us/library/ms365941.aspx

To change the password used by the SQL Server Agent service, do the following:
  1. Run Start -> All Programs -> Microsoft SQL Server 2008 -> Configuration Tools -> SQL Server Configuration Manager
  2. In SQL Server Configuration Manager, click SQL Server Services
  3. In the details pane, right-click SQL Server Agent (<instancename>) and choose Properties
  4. In the SQL Server Agent (<instancename>) Properties dialog box, switch to the tab "Log On"
  5. For the account listed in the Account Name box, type the new password in the Password and Confirm Password fields and then click "OK"
Note: When performing step 4, you may encounter the error WMI Provider error: Access is denied. This problem may be worked around as described in http://blogs.msdn.com/psssql/archive/2009/01/21/wmi-provider-error-access-is-denied-while-changing-sql-server-account-password.aspx.

In short, before changing the password, use Browse to select the proper account.

The changes take effect immediately, without restarting the SQL Server.

The same procedure may be used for the SQLBrowseAccount user (use SQL Server Browser instead of SQL Server Agent).


2. Use this article for MS SQL Server 2005: http://msdn.microsoft.com/en-us/library/ms365941(SQL.90).aspx

To change the password used by the SQL Server Agent service, do the following:
  1. Run Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager
  2. In SQL Server Configuration Manager, click SQL Server 2005 Services
  3. In the details pane, right-click SQL Server Agent (<instancename>) and choose Properties
  4. In the SQL Server Agent (<instancename>) Properties dialog box, switch to the tab Log On
  5. For the account listed in the Account Name box, type the new password in the Password and Confirm Password fields and then click "OK"
Note: When performing step 4, you may encounter the error WMI Provider error: Access is denied. This problem may be worked around as described in http://blogs.msdn.com/psssql/archive/2009/01/21/wmi-provider-error-access-is-denied-while-changing-sql-server-account-password.aspx.

In short, before changing the password, use Browse to select the proper account.

The changes take effect immediately, without restarting the SQL Server.

The same procedure may be used for the SQLBrowseAccount user (use SQL Server Browser instead of SQL Server Agent).

3. Restart corresponding services.

37e602325b9e080e0d137546b764143c 5356b422f65bdad1c3e9edca5d74a1ae 80fcf07a72a3fc2739554dff85ce8fe7 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF