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?
Are you testing failover after setting up ActivePassive cluster ? If yes try steps below in link http://msdn.microsoft.com/en-us/library/ms189117.aspx
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.