Instance failover failing in Cluster

Question

Instance failover failing in Cluster

Benki Chendu

SSCrazy Eights

Points: 8051
More actions
April 19, 2014 at 10:12 pm

#288143

I am getting the following error when I am trying to failover an instance to another node:
The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group.
I remember vaguely that add node was already done on this node and failover testing was made. Any idea why am getting such error?
My server is SQL 2008 R2 SP2

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

Benki Chendu SSCrazy Eights Points: 8051 More actions · Answer 1

I also ran the following command and it showed up the node which isnt taking the instance's name also in the result set:

SELECT * FROM sys.dm_os_cluster_nodes

Benki Chendu SSCrazy Eights Points: 8051 More actions · Answer 2

I also verified that add node was already done earlier.

I just ran the SQL Server setup again and there wasn't any instance pending when I ran the add node option.

Joie Andrew One Orange Chip Points: 27360 More actions · Answer 3

Is the node that you are trying to failover to listed as a possible owner for the cluster resources in cluster admin?

Joie Andrew
"Since 1982"

Perry Whittle SSC Guru Points: 234013 More actions · Answer 4

Benki Chendu (4/19/2014)
I am getting the following error when I am trying to failover an instance to another node:
The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group.
I remember vaguely that add node was already done on this node and failover testing was made. Any idea why am getting such error?
My server is SQL 2008 R2 SP2

Run the following Powershell command to list the resource possible owners. Replace the string with the name of your clustered role

get-clusterresource | ?{$_.OwnerGroup -EQ "yourclustergroup"} | get-clusterownernode | fl

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Benki Chendu SSCrazy Eights Points: 8051 More actions · Answer 5

Benki Chendu

SSCrazy Eights

Points: 8051

April 21, 2014 at 12:17 pm

#1707531

Yes. It is listed as a possible owner..

Benki Chendu SSCrazy Eights Points: 8051 More actions · Answer 6

Perry Whittle (4/20/2014)
Benki Chendu (4/19/2014)
I am getting the following error when I am trying to failover an instance to another node:
The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group.
I remember vaguely that add node was already done on this node and failover testing was made. Any idea why am getting such error?
My server is SQL 2008 R2 SP2
Run the following Powershell command to list the resource possible owners. Replace the string with the name of your clustered role
get-clusterresource | ?{$_.OwnerGroup -EQ "yourclustergroup"} | get-clusterownernode | fl

Have never used PS earlier. How and where would I run this 😎

Perry Whittle SSC Guru Points: 234013 More actions · Answer 7

Benki Chendu (4/21/2014)
Perry Whittle (4/20/2014)
Benki Chendu (4/19/2014)
I am getting the following error when I am trying to failover an instance to another node:
The operation failed because either the specified cluster node is not the owner of the group, or the node is not a possible owner of the group.
I remember vaguely that add node was already done on this node and failover testing was made. Any idea why am getting such error?
My server is SQL 2008 R2 SP2
Run the following Powershell command to list the resource possible owners. Replace the string with the name of your clustered role
get-clusterresource | ?{$_.OwnerGroup -EQ "yourclustergroup"} | get-clusterownernode | fl
Have never used PS earlier. How and where would I run this 😎

If you run the command directly on the cluster node just open the Powershell command window and paste the command in. You may need to import the failover cluster module, use the following to do this

import-module failoverclusters

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Perry Whittle SSC Guru Points: 234013 More actions · Answer 8

Benki Chendu (4/21/2014)
Yes. It is listed as a possible owner..

possible owner of which resources?

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Benki Chendu SSCrazy Eights Points: 8051 More actions · Answer 9

I will try to run the PS command and come back with results.