Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Instance failover failing in Cluster Expand / Collapse
Author
Message
Posted Saturday, April 19, 2014 10:12 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, October 18, 2014 9:03 PM
Points: 202, Visits: 358
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
Post #1563309
Posted Saturday, April 19, 2014 10:23 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, October 18, 2014 9:03 PM
Points: 202, Visits: 358
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
Post #1563310
Posted Sunday, April 20, 2014 2:35 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, October 18, 2014 9:03 PM
Points: 202, Visits: 358
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.
Post #1563314
Posted Sunday, April 20, 2014 6:23 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Yesterday @ 4:14 AM
Points: 709, Visits: 1,430
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"
Post #1563331
Posted Sunday, April 20, 2014 10:44 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:08 PM
Points: 6,474, Visits: 13,933
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"
Post #1563342
Posted Monday, April 21, 2014 12:17 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, October 18, 2014 9:03 PM
Points: 202, Visits: 358
Yes. It is listed as a possible owner..
Post #1563576
Posted Monday, April 21, 2014 12:24 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, October 18, 2014 9:03 PM
Points: 202, Visits: 358
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
Post #1563581
Posted Monday, April 21, 2014 1:41 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:08 PM
Points: 6,474, Visits: 13,933
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"
Post #1563602
Posted Monday, April 21, 2014 1:42 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:08 PM
Points: 6,474, Visits: 13,933
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"
Post #1563604
Posted Wednesday, May 7, 2014 8:08 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, October 18, 2014 9:03 PM
Points: 202, Visits: 358
I will try to run the PS command and come back with results.
Post #1568489
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse