Has anyone able to add FCI and standalone to an AG? I am getting sql server error 19405 - If one replica is failover cluster instance, remove the overlapped node from its possible owners and try again.
We have a cross-datacenter cluster (4 nodes). Node 1 & 2 on datacenter A (DCA) and Node 3 & 4 on datacenter B (DCB). Nodes 1 & 3 have an FCI and a standalone instance (the AG is on the standalone instance). Nodes 2 & 4 have a standalone instance for the other half of the AG.
Node 1 has a primary AG group that does secondary on nodes 2, 3, and 4. Node 2 has a primary AG group that does secondary on nodes 1, 3, and 4. Nodes 3 and 4 are failover only so do not have anything but secondary AGs and are our secondary DR for the FCI.
AFAIK you can't put the AGs on the FCI. They must be on the standalone instances only. Our FCIs are for other clustered databases that are not part of the AGs.
Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.