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 | flHave 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" 😉