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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!