Problem:
Backup maintenance job for BizTalk 2006 R2 On a Microsoft SQL Server 2005 installation with a linked server
configured to another sql server instance fails with error:
Msg 7411, Level 16, State 1, Procedure sp_BackupAllFull, Line 70
Server 'sql01\other' 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'
Another way to see what the settings are is to go to the management stuio console open in the left panel the "server objects" -> "linked servers" and right click on the server and click on properties.
If you want to change the RPC settings you can set the 'rpc' and rpc-out' property true.