I have two SQL servers that have a SQL login with the same password defined as "SQLUditor" I have a link I want to make the server where only the user can "jump" on the other server. I try to do this via SSMS. On the Security tab, I use Login as a local login and remote user. At the bottom of the dialog box, I indicate the above login, no connection has been made. When I click OK, I get an error message:
Access to the remote server is denied because there are no login mappings. (Microsoft SQL Server, Error: 7416)
Any suggestions? Thank you.
Please create a proper user mapping. More about this protection is listed here:
No comments:
Post a Comment