Installation Guide › Installing CA Virtual Assurance › How to Adjust SQL Server User Permissions to the Required Minimum › Change the Owner of the aom2 and dpm Databases

Change the Owner of the aom2 and dpm Databases

The CA Virtual Assurance installation creates two databases: dpm and aom2. Change the database ownerships to the sa user or to the local administrator.

Windows Authentication

Follow these steps:

1. Log in SQL Server using administrator (sa) permissions or the local system administrator.
2. Click New Query.

   The SQL console opens.

3. Enter the following SQL commands:

   use dpm
   exec sp_changedbowner 'system\administrator', 'true'
   use aom2
   exec sp_changedbowner 'system\administrator', 'true'
   

4. Click Execute.

   The local system administrator owns the aom2 and dpm databases.

SQL Server Authentication

Follow these steps:

1. Log in SQL Server using administrator (sa) permissions.
2. Click New Query.

   The SQL console opens.

3. Enter the following SQL commands:

   use dpm
   exec sp_changedbowner 'sa', 'true'
   use aom2
   exec sp_changedbowner 'sa', 'true'
   

4. Click Execute.

   The sa user owns the aom2 and dpm databases.