SQLTeam.com | Weblogs | Forums

AAG Syncing with WFCS


Have 2 stand alone installed SQL Server 2012 EE machines configured as an AAG redundant pair. WFCS is setup and fails over the v-name/IP correctly. AAG is also setup and independently fails over correctly.

Only problem is the WFCS and AAG are not syncing the v-name/IP fail over meaning you can have the active data on Node 1 and the v-name failed over to Node 2 - so apps cannot function correctly against the read only copy.

Presume you need to get AAG using the Quorum so both WFCS/AAG fail over together. Thought this was setup using the listener but on the system I'm working on this does not work.

Any ideas?