error 7416 access to remote server is denied
Results 1 to 3 of 3

Thread: error 7416 access to remote server is denied

  1. #1
    Join Date
    Jan 2007
    Posts
    36

    error 7416 access to remote server is denied

    hey guys i am getting this error on my link server it is sqlsqever to sqlserver link

    error 7416 access to remote server is denied because no loggin mappings exists

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    How did you map db user to remote sql login in linked server?

  3. #3
    Join Date
    Jan 2007
    Posts
    36
    I got it the problem was the connection not to be made if you are not on the list of the mapped users.

    Solution:I choose the option connection be made using the following security context: and i created a log in with permissions she wanted on the that server.

    Thank u guys.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •