Change database account password in monitored instance. (4326116)

How to change the Performance Analysis database account password in the monitored instance?

Resolution 1:

1. After changing the database account password on the monitored instance, go to the client PC where the Performance Analysis client is installed and click "Start | Programs | Quest Software | Performance Analysis | Agent Administration | Support Utilities"

2. Select the database with the recent password change and connect

3. Click the "Verify Accounts" link

4. On the Accounts dialog, click the "Verify Accounts" button to begin the process

5. The Edit Account dialog will open and prompt for the new password

6. After entering the new password, the utility should complete the process. Next click the "Close" button.

7. Verify Performance Analysis client allows connection to the monitored instance

Resolution 2:

If resolution 1 does not work, try the following:

1. On the Middleware machine, go to "$PA_HOME\<Hostname>-<Instance>\quest_sc_mw\config" directory
2. Find file "quest_sc_mw.cfg" and make a backup copy!
3. Edit the "quest_sc_mw.cfg" file and change the parameter for pass=”xxxxxxxxxxxxxxx” and user =”xxxxx” to the new values and save the file:
   Example:
   <db application_intent="" database="master" db_connection="dbc_DB_AUTHENTICATION" enc_type="new" extra_info1="000007FEF5DB2180" extra_info2="11.0.2100.60" pass="8f178906460ae65819ff842fee606160" port="0" sid="TESTDB" use_old_driver_first="" user="PA_user"/>
   
   Change it to:
   <db application_intent="" database="master" db_connection="dbc_DB_AUTHENTICATION" enc_type="new" extra_info1="000007FEF5DB2180" extra_info2="11.0.2100.60" pass="myNewPassword" port="0" sid="TESTDB" use_old_driver_first="" user="PA_user"/>
4. Finally restart the Performance Analysis middleware and collector.