We help IT Professionals succeed at work.

Cluster Preferred Owners automatically changed to "Anynode" after reboot

75 Views
Last Modified: 2018-12-20
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

SQL Server DBA & Architect, EE Solution Guide
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
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
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

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
CERTIFIED EXPERT
Awarded 2009
Distinguished Expert 2019

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

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.