We are installing a vendor-developed application that requires linked servers between the vendor database’s server and many of our other servers. It has been set up and tested effectively, but it should be noted that it is a double hop to the servers. Server A (which houses the application) queries the linked server defined on Server B, which then queries Server C. The queries work at first, but eventually we receive this error message from Server A:
"Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITYANONYMOUS LOGON'."
If we run the same query through Server B, it works, but Server A returns the same error message 10 minutes later. All our machines run SQL Server 2005 on Windows Server 2003. Do you have any idea why this might be happening?