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"