April 17, 2009 at 11:29 am
If i have sql account on Server A, cna i give that account any type of access on server B. I was just wondering if sql server account is related and works only under that server not other servers.
April 17, 2009 at 11:31 am
I do have all windows authenticated Link servers between the server.
April 17, 2009 at 12:25 pm
If the login is a SQL Server based one, no. They exist on the one server only. However, when you create a linked server connection, you can map the login to a different login on the second server. But this would require additional configuration of the linked server.
K. Brian Kelley
@kbriankelley
April 17, 2009 at 12:27 pm
could you please let me know how i would configure a sql login to access another server through link server and how wud i set what kind of access sql login will have on another server.
April 17, 2009 at 1:20 pm
This explains how it all works:
Books Online: Security for Linked Servers
K. Brian Kelley
@kbriankelley
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply