A remote monitoring is established to a SQL server database which is in an alwayon availability group.
After the availability group failovers from primary to secondary replica, the monitoring side system (like Solution Manager system or some SAP system monitors the remote systems by DBACOCKPIT ) cannot access the remote database.
Following error occurs in SM21 log of monitoring system:
Logon Error: 18456, Severity: 14, State: 38.
Logon Login failed for user '<SID>_SAPMonitor'. Reason: Failed to open the explicitly specified database '<SID>'.
Remote SQL Server version as of SQL Server 2012.
KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.