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”
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”.