Transactional Pull Replication Subscription Error

[johnturgoose]

I am replicating from SQL 2000 to SQL 2005 using a transactional replication with a pull subscription set to pull every hour.

This will work fine but occasionally one hour it will return the error:

Unable to start execution of step 1 (reason: JobOwner DOMAIN1\Administrator doesn't have permissions to use proxy 43 for subsystem Distribution). The step failed.

It will then work fine the following hour.

Any ideas as to what might be causing this seemingly random error would be most appreciated.

Cheers
John

 

[mrdenny]

Typically errors along this line indicate a problem with the SQL Server talking to the domain controllers.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com