Question about sp_addlinkedsrvlogin

[katbear]

Hi,

I realize that I don't really understand how sp_addlinkedsrvlogin works.

If you have a local user that you want to be able to log on to a remote (linked) server, does that user also have to exist on the remote server?

Or if by using sp_addlinkedsrvlogin, does it enable the local user to have access to the remote server even if the account doesn't exist on the remote server? In which case, do the local permissions "transfer" over to the remote server?

Or it is a matter of "linking up" the local user to another user on the remote server?

Reading BOL has only added to my confusion.

Thanks

 

[ptheriault]

If you have a local user that you want to be able to log on to a remote (linked) server, does that user also have to exist on the remote server?

Yes. That is how you login to the link server.

sp_addlinkedsrvlogin does not make any changes to the link server. you must define roles and database permissions first.

- Paul
- If at first you don't succeed, find out if the loser gets anything.