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?