Friday, 16 January 2015

Failover Cluster - Moving SQL Server 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 SQLNODE2" did not complete.

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

node is owner of the group:
cluster res "SQL Server" /listowners
Node 2 doesn't exist in cluster owner group add it: 
cluster res "SQL Server" /addowner:SQLNODE2

trying to add again getting error

Oops forgot Add Node 
Switch to SQLNODE2 Machine, Mount the Sql server software, Click setup 
You can find ADD NODE option , Click on that button and continue..

Once added, then try to move Node1 to Node2. Then it will move

Popular Posts