October 23, 2012

Failover Cluster - Moving resource error

When trying to move "SQL Server (MSSQLSERVER)" service to second node we receive next error:

The operation has failed.
The action "Move to node SQL2" did not complete.

Error Code: 0x80071398
The operation failed because either the specified cluster node is not owner of the group, or the node is not a possible owned of the group

First of all we need to check if node is owner of the group:
cluster res "SQL Server" /listowners
If node doesn't exist in cluster owner group add it:
cluster res "SQL Server" /addowner:SQL2
Where "SQL Server" - name of clustered service or application; SQL2 - name of second node.

Second step is checking if second node is a possible owner of the group:
1. Go to cluster shared disk
2. Click Properties, Advanced Policies
3. Make sure that second node checkbox is checked.

1 comment: