Server ‘myserver’ is not configured for RPC

20 Jan

I received this error when trying to run a stored procedure from a linked server earlier today. The fix was to run this command on the box that you are receiving the error:

exec sp_serveroption @server=’myserver’, @optname=’rpc’, @optvalue=’true’
exec sp_serveroption @server=’myserver’, @optname=’rpc out’, @optvalue=’true’

(replace ‘myserver’ with the name of the linked server)