SQL SERVER – Server ‘xxx’ is not configured for RPC

While calling a Stored procedure on a linked Server I face this error : “Server ‘xxx’ is not configured for RPC”

Open the linked server properties and go to the Server Options tab, there is an option for RPC and RPC Out.  RPC Out needs to be set to True in order to execute a stored procedure that is stored on the linked server. RPC allows stored procedure call from the linked server whereas RPC Out allows stored procedure calls to go out to the linked server.

Leave a comment