Aug
21
awarded  Notable Question
Mar
21
awarded  Popular Question
2018
Aug
23
comment AlwaysOn Error: The target database is participating in an availability group and is currently not accessible for queries
Hi, Anyone encountered the issues, even we try different combination in primary role ( read/write both replica, previously ALL) and readable secondary (yes both replica), the availability group failover is setup to "synchronous commit", configure the read only routing correctly. No problem with connecting and committing transaction in application when primary is Node1 but when manual failover to Node2 (becomes primary replica), it doesn't allow to commit transaction (DML) in application side.
Aug
9
awarded  Student
Aug
9
asked AlwaysOn Error: The target database is participating in an availability group and is currently not accessible for queries