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 'myserver' 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, run on the client server (not the linked server).
If 'rpc,rpc out' is not in your results, then the the linked server isn't configured for RPC. To do so, run these two commands on the client server:
exec sp_serveroption @server='myserver', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='myserver', @optname='rpc out', @optvalue='true'