Tags » AlwaysOn
Error faced while running simple commands like “sp_who2” :
Msg 978, Level 14, State 1, Procedure sp_who2, Line 89
The target database (XXX) is in an availability group and is currently accessible for connections when the application intent is set to read only. 57 more words
We have Always-On configured between Node-1, Node-2 with Auto Failover enabled. Unfortunately one minor functionality was partially impacted when AG is primary on Node-2.
Business is very particular about not changing it to Manual Failover mode. 293 more words