SQL Server Troubleshooting
Distribution Agent: The process could not connect to
A distribution agent has failed, the full error message
The process could not connect to Subscriber 'XXXX'
where 'XXXX' is the name of the subscriber it was trying
to connect with.
Possible Causes and Remedies:
- The link to the subscriber or the subscriber-server
is down. Try pinging the subscriber. If pinging is unsuccessful then
resolve the network connectivity problem first.
- The login account that the subscriber is using is not
a valid account on the subscriber server. (For example if using the
'system' account instead of a domain account.)
The account that is used can be found under 'Tools',
'Configure Publishing, Subscribers and Distribution...', select
the 'Subscribers' tab and double click the subscriber to show its
These notes are believed to be correct for SQL
Server 7 and may apply to other versions as well.
About the author: Brian Cryer
is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.