Login failed for user(‘null’)

I’ve found this problem on a transactional replication under SQL Server 2000 (yes! a lot are still running on production systems !!!)

Subcription_history
Error messages:
Login failed for user ‘(null)’. Reason: Not associated with a trusted SQL Server connection. The process could not connect to Distributor ‘xxxxxxx’. The step failed.

Solution:

After investigating for logins, rights and so on…I figured out it was an impersonation problem, like when you go through DCOM with a wrong impersonation (dcomcnfg)

Looking at the subscripton properties if found out a parameter was activated (offload agent processing). This parameter indicates whether you use the remote agent with DCOM, by assigning the name of the remote server (pull subscriptions)

Subscription_properties

By disabling this parameter (setting it to false) the replication immediatly ran perfectly.