September 28, 2017 at 5:20 am
Hi ,
We have a 2 Node SQL Server Failover Cluster and another node with Always ON. Now in Always On I cannot set primary for Automatic failover mode even though its in Synchronous commit. Getting below message ,Any help is greatly appreciated.
The Alter operation is not allowed on availability replica '',
because automatic failover mode is an invalid configuration on a SQL Server Failover Cluster Instance.
Retry the operation by specifying manual failover mode. (Microsoft SQL Server, Error: 35215)
Thanks in Advance
September 29, 2017 at 5:02 am
automatic failover cannot be configured between 2 replicas when one of the replicas is a failover cluster instance.
This is by design
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 1, 2017 at 2:59 am
Perry Whittle - Friday, September 29, 2017 5:02 AMautomatic failover cannot be configured between 2 replicas when one of the replicas is a failover cluster instance.
This is by design
Thanks Perry .
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply