Posted by Marcos Freccia
One of the possible scenarios for SQL Server FCI to AG migration is adding a third node to the Windows Failover Cluster and creating an Availability Groups between the FCI and the third standalone SQL Server, or having one node as FCI and the other node as a standalone SQL.
In my case I am running with the second option. I have one node with SQL Server 2014 FCI and the other node SQL Server 2016 Standalone, but the servers are in the Windows Cluster. When you try to create the Availability Groups between them you get the following error. Read the rest of this entry →
Tags: berlin, Failed to create join or add replica to availability group because node is a possible owner for both replica and, FCI and Availability Groups, germany, If one replica is failover cluster instance remove the overlapped node from its possible owners and try again, Migrating SQL Server FCI, SQL Server Beratung, sql server berlin, sql server consulting, SQL Server FCI and AG