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’, …

Read more »