Issue with connectivity from MS SQL with 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://xxx.qa.com:<port>;selectMethod=cursor;DatabaseName=XXXX;multiSubnetFailover=true
Below are the error
Tue Jan 18 15:49:14.298 2022 WARNING: pid 30558 tid 30558: 2: 0: ArDBConnection::connect: Connection to database [arcotdsn]. user [SVC.WAMATHOWNER] 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.]
Tue Jan 18 15:49:14.298 2022 WARNING: pid 30558 tid 30558: 2: 0: ArDBPool::createNewConnections: Failed to grow the pool [(primary)] : Error [ArDBPool::createDBContextObjs: 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)
RiskMinder(Arcot RiskFort)
Resolution
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://xxx.qa.com:<port>;selectMethod=cursor;DatabaseName=XXXX;multiSubnetFailover=true
Additional Information
Feedback
