We added a new node to a SQL cluster but get the error:
System error 5016 has occurred (0x00001398).
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.
cluster res "SQL Server Agent" /listowners does not list the new node. The new node is listed in the other resources as a possible owner.
What is the best way to correct this?
I found one page that said to just copy over
Windows\systems32\SQAGTRES.DLL to the new node from one of the other nodes and that is all it would need. That seems a bit too much like a kludge though I have no idea if it normal to do this.
Thanks