June 7, 2013 at 5:05 am
Hi all,
I need to call a SP on a remote server and im finding Linked servers to be troublesome to say the least.
Ive enabled RPC and RPC Out.
If I set up a linked server from SA on Server A to SA on Server B it will run
If i set up a linked server from SQL User A (With SysAdmin rights) to SQL User B (With SysAdmin rights) it fails with the error:
Msg 7416, Level 16, State 1, Line 1
Access to the remote server is denied because no login-mapping exists.
If i try using AD accounts (both with SysAdmin rights) it still fails.. again always with the same error message??
any ideas whats going on?
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy