Issue with connectivity from MS SQL with Advanced Authentication product using multiSubnetFailover
search cancel

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

book

Article ID: 234252

calendar_today

Updated On:

Products

CA Advanced Authentication - Strong Authentication (AuthMinder / WebFort)

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.

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

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

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)