SQL Server Performance

resource not moving to the other node

Discussion in 'SQL Server 2005 Clustering' started by amara, Mar 19, 2009.

  1. amara Member

    Hi All,
    we have a 2 node cluster for SQL Server 2005. when we are trying to move the entire group to the other node, its going offline and within a fraction of a second, its coming back to the same node.
    when we checked the error logs, we found the below error.ODBC error: (28000) - [Microsoft][SQL Native Client][SQL Server]Login failed for user 'NT AUTHORITYANONYMOUS LOGON'
    Please help me out in fixing this issue?
  2. techbabu303 New Member

  3. SCFlabbergaster New Member

    Looks like you don't have a cluster service user set up. How long have you had it up and did you test the failovers successfully both in Windows and in SQL Server when it was set up? There are also several User Rights Assignments that have to be set in the Domain Security Policy in your Active Directory Server. Specifically, the account has to be added to:
    • Act as part of the operating system
    • Adjust memory quotas for a process
    • Back up files and driectories
    • Debug Programs
    • Impersonate a client after authentication
    • Increase Scheduling Priority
    • Log on as a service
    • Manage Auditing and Security Log
    • Restore files and directories
    Also, it should be noted that in each of these User Rights Assignments, if there are no users or groups in them to begin with, there are automatic default groups that they apply to. If you are adding in these users (in lieu of adding the users to the default groups, which may violate the principle of least privilege) and there are none listed, you should determine what groups are the default groups and add them explicitly as well. Hope this all helps. These were a few gotchas that we had to work hard to straighten out.
  4. satya Moderator

    Check the cluster log for more information on why the failover of node is not completed.

Share This Page