Installation Guide › Plan Your Installation › How to Adjust SQL Server User Permissions to the Required Minimum › Change the Owner of the aom2 and dpm Databases to sa

Change the Owner of the aom2 and dpm Databases to sa

During the installation process, two databases for CA Server Automation are created: dpm and aom2. Change the ownership of these databases to the sa user.

Follow these steps:

1. Log into SQL Server using the sa user.
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.