Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 High Availability (2008)
 Unable to fail instance to 2nd node in cluster.

Author  Topic 

MediaPirate
Yak Posting Veteran

52 Posts

Posted - 2010-08-03 : 21:13:14
I have a two node cluster, running on Windows 2K8 R2 x64 Ent and SQL 2k8 R2 x64 STD. I have two instances setup one instance on each node. I ran through the validation tests on the cluster but I'm unable to failover either instance to their opposite node. I get the error message "Error Code: 0x80071398" The operation failed because either the specified cluster node is not the owner of the group, or the node is not possible owner of the group.

I researched the error but everything I've found so far is focused on Exchange but it's the same error so I applied the solutions. It seems the resources "typically the IP" aren't setup for both nodes. I've gone through all the resources for both nodes and make sure the owner for each resource included both nodes to no avail. I'm completely stuck at this point any help would be appreciated.

MediaPirate
Yak Posting Veteran

52 Posts

Posted - 2010-08-03 : 21:54:10
Ok, I found the issue, I missed assigning one of the clustered resources to the 2nd node.
Go to Top of Page

Bruce Sherwood
Starting Member

12 Posts

Posted - 2010-09-02 : 20:01:01
Fascinating.

R2 brings a lot of simplification to the whole process of setting up a cluster, but along the way some things just slip through the cracks.

Good job figuring it out. A good lesson for all of us.
Go to Top of Page

taggs
Starting Member

7 Posts

Posted - 2011-01-15 : 06:39:35
I have the same problem but I have checked all resources and they are all assignened to both nodes. Is there any suggestions?
Go to Top of Page

taggs
Starting Member

7 Posts

Posted - 2011-01-16 : 06:49:53
OK I found my problem, fat fingers! I was using the wrong netmask on the other node!
:-S
Go to Top of Page
   

- Advertisement -