CA RiskMinder Windows Installation Guide › Preparing for Installation › Configuring Database Server › Configuring Microsoft SQL Server › Creating a Database User

Creating a Database User

To create a database user, use the following steps:

Note: SQL Server refers to a user as a Login.

1. In the SQL Server Management Studio, go to <SQL_Server_Name>, expand the Security folder, and then click Logins.

   Note: The <SQL_Server_Name> refers to the host name or IP address of the SQL Server where you created your database.

2. Right-click the Logins folder, and click New Login.
3. Enter the Login name. The recommended name is arcotuser.
4. Set the following parameters:
   1. Authentication to SQL Server Authentication.
   2. Specify Password and Confirm password for the login.
   3. Ensure that you specify other password settings on this page according to the password policies in your organization.
   4. Default the database to the database (arcotdb) you created.
   5. User Mapping for the login (in the Users mapped to this login section).
   6. User Mapping (SQL 2005) for the default database to db_owner (in the Database role membership for: <db_name> section).