Cluster's SQL agent resource does not list available node as a possible owner

  • 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

Viewing 0 posts

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