CA Strong Authentication UNIX Installation Guide › How to Configure the Database Server › SQL Server Configuration › Create a Database User

Create a Database User

Perform the following steps to create a database user:

Follow these steps:

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 to 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).