none
SQL Server 2016RC2 AlwaysOn with csv 创建availability group 时 提示Failed to create, join or add replica to availability group RRS feed

  • 问题

  • os : windows 2012 R2, 

    DOMAIN: q16rc2.com 

    cluster 里面有四个nodes:

    NODE1, NODE2 上创建failover cluster instance :MSSQLSERVER1,SERVER NAME: SQL16CSVAO1,位置在一个CSV(cluster share volume)盘里

    NODE3,NODE4上 创建failover cluster instance :MSSQLSERVER2,SERVER NAME: SQL16CSVAO2.位置在另外一个CSV(cluster share volume)盘里

    最后创建availability group时 总是出错提示Failed to create, join or add replica to availability group 'Q16CSVAOHG', because node 'node3' is a possible owner for both replica 'SQL16RC2CSV1\MSSQLSERVER1' and 'SQL16RC2CSV2\MSSQLSERVER2'. If one replica is failover cluster instance, remove the overlapped node from its possible owners and try again。

    请问怎么解决?

    另外,再网上搜过一些答案,说remove the overlapped node from its possible owners,但是这个怎么操作,在哪儿移除?


    2016年4月19日 7:08