Question / Problem:
When configuring Kofax Capture for failover, then the Database Availability Group (DAG) is not properly invoked during a failover.
- Are there any additional MSSQL-specific parameters to be included for Failover operations to work with DAG?
- Does Kofax Capture provide any control of the Failover Operations?
Answer / Solution:
Database Availability Groups are supported even though additional MSSQL-specific parameters are not officially supported.
- Kofax TS recommends including an XML Element within the ACconfig.xml file, as follows:
Please note that Microsoft suggests increasing the value of Connect Timeout to accommodate for failover time and to reduce application connection retry attempts.
Additionally, Kofax Capture product suite is transparent to the database application and would not provide any control of the failover operations.
- See also Always On Failover Cluster Instances (SQL Server) Overview, from Microsoft - SQL Docs