Advanced Authentication DataBase Migration

Products

• CA Strong Authentication
• CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)
• CA Advanced Authentication - Risk Authentication (RiskMinder / RiskFort)
• CA Risk Authentication

Issue/Introduction

Migrating the current DB from existing MSSQL 2017 Farm to a new MSSQL 2019 Farm.

Please share the steps that need to be followed post DB migration.

Environment

Component: Advanced Authentication
Release : 9.1

Resolution

Follow these best practices while migrating DB from one server to another server machine:

1. arcotcommon.ini file located in <ARCOT_HOME>\conf has a section for Primary DB ([arcot/db/primarydb]) and a section for Backup DB ([arcot/db/backupdb]). Please populate these sections with the updated DB hostnames/ports.
   
   
2. For Windows, update the Primary and Backup DSN configuration from odbc application with the updated DB hostname/port and test the connectivity.
   For Linux, update HostName/Port in ARCOT_HOME/odbc64/odbc.ini file in a text editor.
   
   
3. Use the DBUtil utility to change the database user credentials in the securestore.enc file.