After dropping all replication objects and then recreating them the agents were still failing.
The error that was showing stated: server execution failed
Ran the snapshot replication agent from the command line.
To do this go to the sql folder with snapshot.exe In this case C:\Program Files\Microsoft SQL Server\80\COM
Then run snapshot.exe followed by the string found in the second step of the start agent job. In this case: -Publisher [Server2Name] -PublisherDB [replictedDatabaseName] -Distributor [Server2Name] -Publication [nameOfPublication] -DistributorSecurityMode 1
This then generated the real error: ATL71.Dll was missing from – series of directories all defined by PATH.
I did a search and found this dll in the temp directory. I copied it to system32 and re ran the agents.
They are now distributing transactions. It took a while to catch back up again though.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment