Several subscriptions that were on a subscriber server that have the distribution job fired off on a scheduled basis (3-4a in the morning spaced out).
Were working fine as of yesterday but we had to remove the publications and subscribers (after scripting them out) from the server that acts as the Publisher/Distributor (due to data file moves needed on some of the DBs which were moved to larger SAN volumes).
Rebuilt the publications and subscriber from the scripts generated above.
Now on the subscriber server the scheduled distribution jobs are failing with the following error:
--First step history messages say (with success) ...
The replication agent has been successfully started. See the Replication Monitor for more information.
-- Second step message:
2010-03-28 14:42:16.346 The timestamps prepended to the output lines are expressed in terms of UTC time.
2010-03-28 14:42:16.346 User-specified agent parameter values:
2010-03-28 14:42:16.346 Startup Delay: 8299 (msecs)
2010-03-28 14:42:24.643 Connecting to Subscriber 'MyServer'
2010-03-28 14:42:24.721 Connecting to Distributor 'MyDistributor'
2010-03-28 14:42:24.721 Agent message code 20084. The process could not connect to Distributor 'MyDistributor'.
I am able to connect from the subscriber server to the Pub\Dist server via Mgt Sutdio.
I have set the job to use a domain admin account that is for all of our SQL Server services across the environment
The distribution jobs on the Pub\Dist server are there and can be started just fine for each of the publications that are failing
Any help would be great - THANKS!