Cluster Preferred Owners automatically changed to "Anynode" after reboot

Doodad Boy
Doodad Boy used Ask the Experts™
on
I had setup Preferred Owners to User setting. At General tab, i had selected a specific node and tick the node.

After rebooted, the "Preferred Owners" setting Changed to "Any Node"

How to permanently set this as User setting.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
SQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018
Commented:
Just wondering whether you have configured the Preferred owner and set the Order of the Preferred owner by moving UP/DOWN the nodes available.
Shared a link with attachment showing how to move UP/DOWN the owner which will help achieve your requirement..
https://www.techveze.com/preferred-owner-and-failover-settings/
Doodad BoySupprt

Author

Commented:
Hi Raja,

Yep, the preferred owner node has been selected and moved to UP.

But when ever the server been rebooted, the setting changed to "Any Node", and found both node are tick.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
>> But when ever the server been rebooted, the setting changed to "Any Node", and found both node are tick.

Both nodes ticked shouldn't be a problem, if the order is retained, then it should be sufficient as the 1st in the order will be the preferred node at any point in time..
Doodad BoySupprt

Author

Commented:
Hi Raja,

After the preferred node is back Online, the role does not moving back to the preferred node.

Please advise further how to fix this.
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
Sorry, not sure how I missed your response..
Okay, to explain more there are 2 scenarios:
1. Automatic - It will go to the next node in sequence and not the first preferred node.
2. Manual - It will go to the first node in preferred sequence.

For the explanation, you can check the scenarios 1 and 3 in the link below..
https://support.microsoft.com/en-us/help/299631/failover-behavior-on-clusters-of-three-or-more-nodes

Kindly let me know for more details..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial