Issue with connectivity from MS SQL to Advanced Authentication product using multiSubnetFailover

Products

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

Issue/Introduction

We have created MS SQL having 4 server in backend. All are in multiSubnetFailover.

We have updated the connection string in arcotcommon.ini file with required parameter and also odbc.ini file.

jdbc:sqlserver://<HostName>:<port>;selectMethod=cursor;DatabaseName=XXXX;multiSubnetFailover=true

Below is the error

Tue Jan 18 15:49:14.298 2022 WARNING: pid 30558 tid 30558: 2: 0: ArDBConnection::connect: Connection to database [<DSN Name>]. user [<username>] failed. Error detail [SQL State:08S01, Native Code: 0, ODBC code: [CA AA][ODBC SQL Server Wire Protocol driver]Unexpected Network Error.  ErrNum = 9SQL State:HYT00, Native Code: 0, ODBC code: [CA AA][ODBC SQL Server Wire Protocol driver]Timeout expired.]

Environment

Release : 9.1

Component : AuthMinder (Arcot WebFort) Strong Authentication

RiskMinder(Arcot RiskFort) Risk Authentication

Resolution

Advanced Authentication product components uses Progress DataDirect drivers for database connectivity. For the ODBC connection which is used by the Strong Auth and Risk Auth Server, odbc.ini file need to be updated. Below are the instructions listed in Progress DataDirect KB article which need to be used in odbc.ini file.

Knowledge: Support for SQL Server Always On (Application Intent) Multisubnet failover with Connect for ODBC

For JDBC components like the State Manager, Arcot Admin and Arcot UDS, the JDBC URL need to be updated in this format.

jdbc:sqlserver://<HostName>:<port>;selectMethod=cursor;DatabaseName=XXXX;multiSubnetFailover=true

Additional Information

Support for MS SQL Server Always On-Risk Auth (broadcom.com)

Support for High Availability, disaster recovery - JDBC Driver for SQL Server | Microsoft Docs

Connect to an availability group listener - SQL Server Always On | Microsoft Docs

Knowledge: Support for SQL Server Always On (Application Intent) Multisubnet failover with Connect for ODBC (progress.com)