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 <a href="http://msdn2.microsoft.com/en-us/library/ms189804.aspx">sp_helpserver</a>, 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'

Comments

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