January 8, 2009 at 3:01 pm
I have server 1 database a and server 2 database b (sql 2005)
Both servers, i have set up logins DOMAIN\Login user and rights given to the tables and database a, b.
When setting up a linked server from server1 to server 1 i am using the following in the linked server properties:
be made using the login current security context
setting the local login = domain\login user and using impersonate which is ticked.
The only way i can get querires to work is
adding in the local login = domain\login user and leaving the impersonate blank and
have remote user and password (which is a sql login set up on server b).
Is there any way to have to same domain\user being in the setup of the linked servers
rather than setting up separate sql logins.
Thanks
January 8, 2009 at 3:05 pm
There is a way to have users have the same SID across servers that might solve your problem.
January 8, 2009 at 3:06 pm
It can be done, through Kerberos (or however that's spelled). I don't know the details, since I had a domain admin do the work for me.
The other option is to allow "anonymous logon" at the target server. That's easy to do, but I'm told it has other security issues.
- 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
January 8, 2009 at 3:55 pm
http://support.microsoft.com/kb/246133
This is just to set up the logins which is what i have done set up the logins to be identical on each server, but thanks anyway.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply