Recently one of my colleague reached out to me with an error message as : “Server is not configured for RPC”
This a typical issue with Linked Server. When we configure a linked server, we need to set up the right values for RPC & RPC Out . We can see these values in SSMS -> Right click on Linked Server -> Properties -> Server Options as in the below screen shot.
|RPC / RPC Out||RPC stands for Remote Procedure Call and allows you to run stored procedures on the Linked Server. RPC enables Remote Procedure Calls from the specified server and RPC OUT enables Remote Procedure Calls to the specified server.|
Hope this helps; If you enjoyed this blog post, feel free to share it with your friends!