We have a 2 Node AlwaysOn Availability Group in SQL Server 2014 running on Hyper-V (VM).
SRV01: Role: PRIMARY READABLE SECONDARY: NO
SRV02: Role: SECONDARY READABLE SECONDARY: YES
We do Manual Failover to Secondary Replica (
SRV02 becomes primary and
SRV01 becomes secondary). During testing our Application uses the AG Listener connection (INSERT/UPDATE TRANSACTION) and we have encountered an error stating:
"The target database XXXXXX is participating in an availability groups and current not accessible for queries. Either the data movement is suspended or 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. (Microsoft Error: 976)
Has anyone encountered the same error, and what are your solutions?