September 28, 2004 at 6:21 pm
Hello everyone,
I have a domain user who has login to two different sql servers. I add a linked server from one to another and add her login name under Local Login and add her login name and password in Remote User/Remote Password. Is this the right way to set it up? She is not able to connect and gets the error: "Login failed for user domainname/username". What am I doing wrong?
October 1, 2004 at 8:00 am
This was removed by the editor as SPAM
October 1, 2004 at 12:17 pm
You are doing everything correctly. You linked her local login to her remote login. It will work if she logs in to server 1 as her local login. But she probably is not. Her Enterprise manager or Query Analyzer are connecting her using her Windows Authentication. And you probably did not linked that. Please, make sure in the Server Registartion Properties for Server 1 in Enterprise manager that the user uses her local login specified in the Linked Server login.
Yelena
Regards,Yelena Varsha
October 1, 2004 at 7:43 pm
if you are using windows authintication this is the simplest setup possible.
on the general tab under type check sql server
on the security tab
check "be made using logins current security context"
If the user has rights setup on the server being accessed by the link they should be able to use the link properly.
Wes
October 1, 2004 at 8:46 pm
This may help:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnnetsec/html/SecNetHT05.asp
Sorry to be vague - no time to look it up again - but I found this was the issue when I had a similar problem.
You may need to give the computers the ability to delegate.
October 5, 2004 at 10:22 am
Hi everyone,
Please accept my delayed thank you, it has been crazy here at work. I appreciate your help, I'll test your input and will report what works. Thanks again.
October 5, 2004 at 10:29 am
Westley, I just tried your approach, and I got the error message:
Error 18456: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Renato, I have let my sys admin know that this needs to be done and we will do what the article says and I will update you with what happens. Thanks.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply