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