Installation Guide › Plan Your Installation › 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 Server Automation with the dbcreator role which you want to use during the installation of the product. After the installation, CA Server Automation can use the same user with different permissions during runtime.

Follow these steps:

1. Login the SQL Server with administrator (sa) permissions.
2. Expand the Security folder in the navigation tree.
3. Right-click the Logins folder and select New Login ...

   The New Login dialog opens.

4. 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".
5. Change to the Server Roles section, add the dbcreator role, and click OK.

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