CA Risk Authentication Windows Installation Guide › Pre-Installation Tasks › Configure Database Server › Configure Microsoft SQL Server

Configure Microsoft SQL Server

This section provides the following configuration procedure for SQL Server:

Note: See the SQL Server documentation for detailed information about performing the tasks listed in this section.

Follow these steps:

1. Verify that SQL Server is configured to use the SQL Server and Windows Authentication mode for Server authentication. Right-click the server in the Object Explorer window and select the Security page.

   CA Risk Authentication cannot connect to the database if SQL Server is configured to Windows Authentication Mode.

2. Create a database by the following criteria:
   • The recommended name is arcotdb.
   • The database size must be configured to grow automatically.
3. Create a DB user (CH4_SQL) by performing the following steps:
   1. In the SQL Server Management Studio, go to <SQL_Server_Name>; expand the Security folder, and then click Login.

      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 Login folder, and click New Login.
   3. Enter the Login name (recommended name is arcotuser).
   4. Set the parameter to Authentication to SQL Server Authentication.
   5. Specify Password and Confirm password for the login.
   6. Ensure that you specify other password settings on this page according to the password policies in your organization.
   7. Make the database (arcotdb) you created as the default database.
   8. Perform the mapping of the users to this login section.
   9. Map the user (SQL 2005) for the default database, to db_owner (in the Database role membership for: <db_name> section).