Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Linked Server to Call SP Expand / Collapse
Posted Friday, June 7, 2013 5:05 AM

Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, September 26, 2016 1:48 AM
Points: 392, Visits: 1,119
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?
Post #1461031
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse