Installation Guide › Installing CA Virtual Assurance › How to Adjust SQL Server User Permissions to the Required Minimum › Create a Database User With the dbcreator Role

Create a Database User With the dbcreator Role

Create a database user for CA Virtual Assurance that you want to use during the product installation and apply the dbcreator role to this user. After the installation, CA Virtual Assurance can use the same user with the appropriate User Mapping settings.

Windows Authentication

Follow these steps:

1. Log in the system using my_domain\my_account or the local system administrator.
2. Log in SQL Server using administrator (sa) permissions or the local system administrator.
3. Expand the Security folder in the navigation tree.
4. Right-click the Logins folder and select New Login ...

   The New Login dialog opens.

5. Under the General section, specify the following settings:
   • Select Windows Authentication.
   • Click Search, enter a login name, for example, my_account, click Check Names.
   • Verify the resolved account my_domain\my_account in the dialog.
6. Change to the Server Roles section, add the dbcreator role, and click OK.

   The new database user has sufficient privileges to install the product.

SQL Server Authentication

Follow these steps:

1. Log in the system using my_domain\my_account or the local system administrator.
2. Log in SQL Server using administrator (sa) permissions.
3. Expand the Security folder in the navigation tree.
4. Right-click the Logins folder and select New Login ...

   The New Login dialog opens.

5. Under the General section, specify the following settings:
   • Enter a login name, for example, causer.
   • Select SQL Server authentication and enter the password for this user.
   • Uncheck "User must change password at next login".
6. Change to the Server Roles section, add the dbcreator role, and click OK.

   The new database user has sufficient privileges to install the product.