Administration Guide › Troubleshooting › CA Server Automation Troubleshooting › Password Changes May Cause Authentication Errors › SQL User Password Change Causes Blank UI

SQL User Password Change Causes Blank UI

Symptom:

I cannot see the CA Server Automation user interface after changing the Microsoft SQL user password.

Solution:

If you are using Microsoft SQL Authentication and you change the password for the Microsoft SQL user (usually the sa password), the CA Server Automation UI is blank or displays Microsoft SQL error messages. Because the product stores the Microsoft SQL user credentials, change them using the following procedure.

To change the SQL user credentials

1. Select Start, Program Files, CA, CA Server Automation, CA Server Automation Command Prompt. Run the following command from the CA Server Automation command prompt:

   dpmutil -set -mgmtdb
   

   You are prompted for the database server, version, port, and the credentials used for accessing the main product tables.

2. If the performance database uses the same database server and SQL user as the management database, run the following command:

   dpmutil -set -perfdb
   

   You are prompted for the server name, administrator user name and password, database type, database instance, and database port.

3. Recycle the CAAIPApache and CAIPTomcat services.