Linked server self-mapping and delegation

Last Post 24 Jun 2009 10:33 AM by ma77g. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

24 Jun 2009 10:33 AM
I've had linked servers under an administrative sql loginfor a while but now we need to let users query in SSMS across linked servers. I don't want then connecting with the admin sql login and I don't think we can use delegation and service Principal Names as our Windows netowrk guys may object.

If thats the case is the best way forward to create a sql login called users_remote for example, put it in the same database roles (ie give it the same permissions) as the users, and then map all their windows logins to it on the linked server?

Acceptable Use Policy