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

Creating a Database User

Use the following steps to create a database user:

Note: MS SQL Server refers to 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.

      Ensure that you specify other password settings on this page according your organization’s password policies.

   3. Default database to the database (arcotdb) you created.
   4. User Mapping for the login (in the Users mapped to this login section).
   5. User Mapping (SQL 2005) for the default database to db_owner (in the Database role membership for: <db_name> section).