November 20, 2008 at 3:56 pm
I am trying to create a linked server from A to B. Both have sql 2005. Services at both servers run under same accont. I am logging in using my domain account with sysadmin priviledges but getting the following error when try to create linked server :
login failed for user 'nt authority anonymous logon'
already check auth_scheme which is kerberos
Don't know what else to do. Please help!
November 20, 2008 at 4:33 pm
Have you tried steps mentioned under http://kendalvandyke.blogspot.com/2008/11/delegation-what-it-is-and-how-to-set-it.html
MJ
November 20, 2008 at 10:30 pm
cherie (11/20/2008)
I am trying to create a linked server from A to B. Both have sql 2005. Services at both servers run under same accont. I am logging in using my domain account with sysadmin priviledges but getting the following error when try to create linked server :login failed for user 'nt authority anonymous logon'
already check auth_scheme which is kerberos
Don't know what else to do. Please help!
link server creation requires the credentials from both sides.
kshitij kumar
kshitij@krayknot.com
www.krayknot.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply