CA Risk Authentication Windows Installation Guide › How to Deploy CA Risk Authentication on Distributed System › Run the Database Scripts

Run the Database Scripts

To run the database scripts, perform the following steps:

Important! Before you run the, verify that you are logged in as the same database user that you created in section, Configuring Database Server.

Follow these steps:

1. Navigate to the following directory:

   <install_location>\Arcot Systems\dbscripts\
   

2. Based on the database that you are using, navigate to the following subdirectories:
   • For Oracle: oracle\
   • For Microsoft SQL Server: mssql\
   • For MySQL: mysql\
3. Run the scripts in the following order:
   1. arcot-db-config-for common-2.0.sql

      Important! If you have installed CA Strong Authentication 8.0, do not run arcot-db-config-for-common-2.0.sql.

   2. arcot-db-config-for-riskfort-8.0.sql
   3. (Optional) only if you want to create the 3D Secure Channel) arcot-db-config-for-3dsecure-8.0.sql.
   4. (Optional) only if you are using User Behavior Profiling, run the following command:

      arcot-db-config-for-userprofiling-2.0.sql
      

Verify the Database Setup

After you run the required database scripts, verify that the CA Risk Authentication schemas are working correctly.

Follow these steps:

1. Log in to the CA Risk Authentication database as the user who installed the database.

   Note: If you are following the upgrade path, then log in to the database as the user who upgraded the database.

2. Run the following query:

   SELECT SERVERNAME, VERSION FROM ARRFSERVERS;
   

   You must verify the following output as a result:

   SERVERNAME                   VERSION
   -------------------------  ----------------
   RiskFort                      8.0
   RiskFortCaseManagement        8.0
   

3. Log out from the database console.