Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Local login on linked server

Hi DBAmp masters,
I want to use few Remote Users depend on Local Login on one Linked Server.
We have a lot of scripts and changing Linked Server name each time based on current user is burdensome, and not always we remember about this.
I created few Remote Users and matched them to Local Logins, but this seems to not works correctly.
Is there a way to do this?
How DBAmp know which user should use now, when I don't have Remote login, only remote Users?
1 person has
this question
+1
Reply