March 5, 2009 at 9:31 am
I created a linked server on sql2005 with windows server 2003, on computer A. I linked to server B with the same credentials, i can see the tables just fine. WHen i login to management studio on my windows xp cpu, and try to connect the linked server, i get a msdasql reported an error, authentication failed error 7399. Is there something i need to configure or change, any help at all would be greatly appreciated.
March 5, 2009 at 9:46 am
Linked servers can't directly pass Windows authentication information more than one link. So if you log in from a workstation to a server (that's not installed on the workstation) and want that server to connect to a different server, it can't do that directly.
There are solutions for this using Kerberos. I'm not familiar with them myself, but I'm sure a Google search will find them for you. The other option is to enable NT AUTHORITY\ANONYMOUS LOGIN on the target server (the one you are linking to). Create that account and grant it the rights you need. That's going to open some security issues (I think).
Another option is to enable SQL logins on the target server and use one of those in the linked server. That's probably the easiest option, and should be secure enough. Just make sure, if you do this, that you keep the sa password highly secure and not blank or something silly like that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply