Issue with connectivity from MS SQL to Advanced Authentication product using multiSubnetFailover
Article ID: 234252
Updated On:
Products
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.
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
Feedback
