Administration Guide › Managing Users and User Groups › Password Management › Change the Database Administrator (sa) Password

Change the Database Administrator (sa) Password

If you use Microsoft SQL Authentication and you change the password for the Microsoft SQL user (typically the ‘sa’ user), change the CA Server Automation password also.

To change the database administrator (sa) password in Microsoft SQL Server

1. Open Microsoft SQL Server Management Studio and log in.
2. In the Object Explorer expand Security, Logins.
3. Open sa and change the password in the right pane.

Note: For further details, see the Microsoft SQL Server documentation.

To change the database administrator (sa) password in CA Server Automation

1. Navigate to Start, Programs, CA, CA Server Automation, CA Server Automation Command Prompt.

   The command prompt appears.

2. Enter the following command:

   dpmutil -set -mgmtdb
   

   The dpmutil command prompts you for the appropriate credentials.

   Complete the command.

3. If the performance database uses the same server and database user (sa), enter the following command:

   dpmutil -set -perfdb
   

   The dpmutil command prompts you for the appropriate credentials.

   Complete the command.

4. Recycle the CAAIPApache  and CAIPTomcat services.

   The credentials are now consistent and CA Server Automation works as expected.