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
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'
imported from old Movable Type blog
author: Kshitij Punjani
date: ‘2007-06-25 15:42:17 -0500’
Nice way out!
Posted with : Tech, Microsoft SQL Server and other databases, SQL Server