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
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
No comments:
Post a Comment