September 11, 2002 at 12:41 pm
My programmer is trying to run a stored procedure which has to connect to a linked server to gather information from a db there. We are receiving the following message:[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Anyone have any ideas?
Thanks,
Tracy
September 11, 2002 at 1:33 pm
Sounds like a double-hop issue. You're using NT authentication to connect to the original server and then connecting to the linked server via NT authentication as well, right?
If that's the case, that's two hops. The only work around (without Kerberos) is to have one connection via a SQL Server login. I gave a bit more thorough explanation here:
http://www.sqlservercentral.com/columnists/bkelley/qa2k_1.asp
Look for the section titled Linked Servers, NT Authentication, and "Double Hop" in the article.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply