Skip to content Skip to sidebar Skip to footer

Sql Server Error: Could Not Execute Remote Procedure

I have three SQL Server 2008 boxes, call them A, B & C. Servers A & B each have a linked server to server C. The linked servers use the exact same linked server setup on

Solution 1:

When a stored procedure is executed, it runs as the security context of the user who created the stored procedure, not the user who is executing it. It is considered a security feature.

It may be that the account used to create the stored procedure on server B does not have the correct rights while the account used to create the stored procedure on server A does.

Recreating the stored procedure on B with another account may solve the problem.

Post a Comment for "Sql Server Error: Could Not Execute Remote Procedure"