June 20, 2013 at 4:55 pm
Hi
I am unable to query the database from my server remotely.
Could you please refer the below pic and tell me the necessary actions. Here I am using the linked server to query the database from my local server(ABC12345) to other server (25.24.147.25), please let me know if you need additional information.
On the other server(25.24.147.25) i do have only read permissions.
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
Thanks
Aswin
June 20, 2013 at 5:12 pm
That error is typically the kerberos double-hop issue. RDC to the machine in question and try to use the linked server from the local SSMS. If it succeeds from there but fails from your desktop SSMS it's definately that.
Google up the issue. It's extensive and the requirements to resolve the issue are logic defying in their depth. It's basically a network administration issue though.
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
June 20, 2013 at 5:28 pm
My guess is the linked server is not setup to pass credentials to the far end of the connection, or as the other responder said it could be a double-hop issue.
CEWII
June 20, 2013 at 5:32 pm
Hi Evil Craig,
Thank you soo much. I appreciate your promt response.
Yes, Exactly it is working from local SSMS and unable to query though clinet. But It solved my problem, all I need to grab grab the data from that server and i got it.
Thanks Again.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply