Symptom
Your SAP NETWEAVER system runs on Microsoft SQL Server database with Always On Availability Groups high availability (HA).
The SQL error log indicates following error message:
------------
yyyy-mm-dd hh:mm:ss Logon Error: 976, Severity: 14, State: 1.
yyyy-mm-dd hh:mm:ss Logon The target database, 'SID', is participating in an availability group and is currently not accessible for queries. Either data movement is suspended or the availability replica is not enabled for read access. To allow read-only access to this and other databases in the availability group, enable read access to one or more secondary availability replicas in the group.
For more information, see the ALTER AVAILABILITY GROUP statement in SQL Server Books Online.
-----------
Read more...
Environment
SAP NetWeaver on Microsoft Windows Server Failover Clustering (WSFC) and SQL Server AlwaysOn Availability Groups.
Keywords
SAP NETWEAVER, Microsoft SQL Server, database, Always On Availability Groups, high availability, HA, SQL Server Always On, Availability Groups, applications, connection, Logon Error: 976, The target database, 'SID', is participating in an availability group and is currently not accessible for queries, Either data movement is suspended or the availability replica is not enabled for read access. , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW on Microsoft 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview