The information in this document is based on these software versions:
CVP Reporting Server 8.5 and above
CVP Operations Console (OAMP)
The information in this document was created from the devices in a specific lab environment. All of the devices used in this document started with a cleared (default) configuration. If your network is live, make sure that you understand the potential impact of any command.
These are the most common symptoms of a bad username and password combination or a locked out account for the CVP Reporting users - cvp_dbadmin and cvp_dbuser and informix database user.
CVP OAMP lists the CVP Reporting Server in a partial state
Informix log file located %INFORMIXDIR%%INFORMIXSERVER%.log contains multiple log lines indicating "Error -951 - Incorrect password or user cvp_dbadmin@<server-name> is not known on the database server
CVP Reporting Server logs contain Purge errors related to Informix error 951
Step 1. Open a Remote Desktop Session to the Reporting Server.
Step 2. Log in to the server with a user who has administrator rights.
Step 3. Ensure that the CVP Reporting users Informix, cvp_dbadmin, cvp_dbuser exist on CVP Reporting Server.
Step 4. CVP Reporting users must be members of local Administrators and Informix admin groups.
Step 5. Ensure the CVP Reporting user accounts are not locked out.
Step 6. Ensure the Reporting Server is STOPPED via CVP OPS console before the Windows Password is changed. If the Reporting Server is not stopped, it will attempt to connect with the bad username/password combination and lock the cvp_dbuser account.
Step 7. Ensure the Cisco CVP Resource Manager service is started and running on the CVP Reporting Server.
Step 8. Navigate to Computer Management > Local Users and Groups > Users.
Step 9. Reset the password for informix, cvp_dbadmin, cvp_dbuser to a temporary password.
Step 10. Navigate to OAMP console webpage > CVP Reporting Server > Select/Edit CVP Reporting Server Configuration > Database Administration > Change User Passwords.
Step 11. Enter the temporary password in step 9 as the old password, and then enter your new permanent password.
Step 12. Ensure the accounts are not locked out through Windows Users & Groups.
Step 13. Restart the CVP Reporting Server service.