December 9, 2010 at 10:22 am
Hi I have a link server created on sql2008 pointing to Sql2005 with Nt login and i am having the error msg Login failed for user 'NT Authorithy\Anonymous logon' Microsoft Sql server ,error 18456 while accessing the linkserver to retrive the data .
is there any solution to get rid of this error message with out using the Sql server authentication?
Thanks in advance 🙂
December 9, 2010 at 10:50 am
You should make sure that you are using a specific proxy account for the linked server. It might be set to use the SQL Server service account by default, and if that is a local account, it might not work across machines.
December 9, 2010 at 10:56 am
Sounds like a classic 'Double Hop' issue. Just google that phrase with sql server and you'll get a ton of information.
The short form is that anything that routes more than once loses its security context and gets denied. Software like Kerberos was designed to deal with this.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 9, 2010 at 2:12 pm
It could most probably be a Double Hop issue as Craig mentioned.
You may not be able to use the Linked Server from your desktop but if you RDP on to the source server and try to execute the queries on Target server, you should be able to do that.
http://blogs.msdn.com/b/sql_protocols/archive/2006/08/10/694657.aspx
Thank You,
Best Regards,
SQLBuddy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply