Problem: On a Microsoft SQL Server 2008 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 'linkedserver' 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='linkedserver', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='linkedserver', @optname='rpc out', @optvalue='true'
Msg 7411, Level 16, State 1, Line 1
Server 'linkedserver' 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='linkedserver', @optname='rpc', @optvalue='true'
exec sp_serveroption @server='linkedserver', @optname='rpc out', @optvalue='true'
Comments