SAP Knowledge Base Article - Preview

3679673 - The target database, 'SID', is participating in an availability group and is currently not accessible for queries. Logon  Error: 976.

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.