Instance failover failing in Cluster

  • 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

  • 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

  • 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.

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

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

  • Yes. It is listed as a possible owner..

  • 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 😎

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

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

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

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

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