Previous Topic: Post-Installation TasksNext Topic: Verify the Database Setup


Run the Database Script

CA Strong Authentication includes with database scripts that create the schema and set initial configuration values in the CA Strong Authentication database.

Follow these steps::

  1. Locate the folder with the scripts for your database type. The default location is:

    (for Microsoft SQL Server) <install_location>/arcot/dbscripts/mssql

    (for Oracle Database) <install_location>/arcot/dbscripts/oracle

    (for IBM DB2 UDB) <install_location>/arcot/dbscripts/db2

    (for MySQL) <install_location>/arcot/dbscripts/mysql

  2. Run the scripts in the following order by using the database vendor tools:
    1. arcot-db-config-for-common-8.0.sql

      Important! If you have installed CA Risk Authentication 8.0, then do not run arcot-db-config-for-common-8.0.sql because you have already run it while installing CA Risk Authentication 8.0.

    2. arcot-db-config-for-webfort-8.0.sql

Note: If you encounter any errors while executing the scripts, then check with your database administrator whether you have the required privileges.