I have a SQL AG running on two nodes WIN 2012 R2.
The node SQL01 is the primary and the SQL02 is the secondary node.
When I go to the AG dash board and start the Failover Wizard from SQL01 to SQL02 , then I get problems.
When the DB is on the SQL02 the DB is not reachable anymore.
As I know the DB is always in sync mode but what about the local users ?
How to handle this ?