SAP system cannot connect to SQL Server after Alwayson availability group fails over to the secondary replication.
The error on developer trace is below:
Invalid object name 'DBPROPERTIES'.
Connection 0 opened (DBSL handle 0)
Invalid object name 'SVERS'.
ERROR: -1 in function StartSelect (execute) [line 13394]
Statement(s) could not be prepared.
LOG BZA=> table SVERS does not exist on database
LOG R19=> ThInit, db_connect
ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1)
SAP application server based on SQL Server Alwayson functionality.
High Availability, Disaster Recovery, secondary, node, fail over,clustering, Return Code 004096, DB-Connect Failed, , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.