Home Forums SQL Server 2005 SQL Server 2005 Security Getting the error: "Access to the remote server is denied because no login-mapping exists" RE: Getting the error: "Access to the remote server is denied because no login-mapping exists"

  • Make sure the login exists on the remote server

    SERVERA (could be sa here)

    SERVERB (put the login thats exists in here).

    Then you can have sa and then impersonate the remote user will be whats on serverb.

    Just for ease add both users to SERVERA and SERVERB make sure works.

    Also the login must have access to the server B database your trying to set link up with.