SAP Knowledge Base Article - Preview

2448122 - Login error happens when a remote monitoring SQL Server in an alwayson failovers

Symptom

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>'.


Read more...

Environment

Remote SQL Server version as of SQL Server 2012.

Product

SAP Solution Manager 7.2

Keywords

KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , Problem

About this page

This 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.