Avatar of Doodad Boy
Doodad Boy
Flag for Malaysia asked on

Cluster Preferred Owners automatically changed to "Anynode" after reboot

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.
Windows Server 2012Microsoft SQL Server* Multi-Site Failover Cluster

Avatar of undefined
Last Comment
Raja Jegan R

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Raja Jegan R

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Doodad Boy

ASKER
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 R

>> 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 Boy

ASKER
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.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
Raja Jegan R

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..