Server 'myserver' is not configured for RPC
June 22, 2007
Problem: On a Microsoft SQL Server 2005 installation with a linked server configured to "myserver" (which happens to be 2000), execution of a remote stored procedure (EXEC myserver.mydatabase.dbo.mysproc) fails with error:
Msg 7411, Level 16, State 1, Line 1
Server 'psp6new' is not configured for RPC.
Solution: Problem is most likely that RPC is not configured for your linked server. That is not a default option, after all. You can see what settings are configured with exec sp_helpserver.
If 'rpc,rpc out' is not in your results, then the the linked server isn't configured for RPC. To do so:
exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'