Periodically, the Log Reader agent fails with the following message:
"The step did not generate any output. The step failed."
After tracing both the Publisher and Distributor servers, it seems to stop at the following statement on the Publisher:
EXECUTE @retcode = @proc
@local = 'local'
where @proc is repl_distributor.master.dbo.sp_helpdistributor
When I try to execute the statement from Query Analyzer, I receive the following error:
Server: Msg 7411, Level 16, State 1, Line 51
Server 'repl_distributor' is not configured for RPC.
I query the master.dbo.sysservers and see an entry for repl_distributor. Here are some of its column values:
There is little, if not any, documentation on the Internet that acknowledges the error. Any help is appreciated.
Replication Type: Transactional
Subscriber 1: ServerC (Push Subscription)
Subscriber 2: ServerD (Push Subscription)
Log Reader Agent on Distributor: Continuous and trusted connection
Distribution Agent for Subscriber 1 on Distributor: Continuous and trusted connection
Distribution Agent for Subscriber 2 on Distributor: Continuous and trusted connection
Immediate Updating: None
Queued Updating: None
Data Transformations: None
Data Filtering: None