Linked Server to Call SP

• Staggerlee

  SSCertifiable

  Points: 5272

  More actions

  June 7, 2013 at 5:05 am

  #294298

  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?