SQL Server RPC Out on Linked Server Properties

22 Oct
October 22, 2011

You have probably reached this page after receiving the following error message: Server ‘SERVERNAME’ is not configured for RPC. [SQLSTATE 42000] (Error 7411). This article will explain why you are receiving this error, and what can you do resolve it.

Essentially you are trying to invoke a Remote Procedure Call (RPC) on the Linked Server, but you have not configured the Linked Server connection to allow sending an RPC to the remote server.

You can Resolve a Server ‘SERVERNAME’ is not configured for RPC. [SQLSTATE 42000] (Error 7411) error by editing the Linked Server Properties, and setting the RPC Out property from “False” to “True”

Linked Server Properties Page

The issue could also be caused by the Linked Server itself not allowing remote RPC calls, in which case you need to configure the RPC property on the remote server itself to “True”.

          0 votes
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>