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.
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
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',
exec sp_serveroption @server='myserver', @optname='rpc out',
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.