January 5, 2011 at 11:43 am
Hi
I do configure all SQL link servers by creating SPN and delegation windows service account, it works pretty good on all the servers but recently when i did the same on [Win 2008/SQL 2008] server it is acting something funky.
when i connect to 2008 sql server from win2003/SQL 2005 and do a query using link server it fails with "NT AUTHORITY\ANONYMOUS LOGON" but when i go back to SQL 2008 server using my rdp session and run the same query it works fine and the interesting thing is after i ran the query on 2008 and come back to server where it faield , it works now and the problem repeats after 10min.
What is causing this?
January 5, 2011 at 1:25 pm
Every 10min? It may because the network or something refreshed...
I am not sure.
But, for your linked server issue, the "ANONYMOUS" means you used the 2-hop connection to the remote server, and remote server can't use kerberos authentication but NTLM authentication. From here, I guess you use "using the login's current security context" in your linked server. If you change to "Using this security context" and supply login/password. It will solve the "ANONYMOUS" issue.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply