Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 5:48 AM
Points: 314, Visits: 729
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