Intermitent Distribution Agent errors

[bmckeen]

I have a replication Push Subscription configured that works most of the time but I get occasional errors satating that "The process could not connect to the Subscripber 'xxxx'". The details are



Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
(Source: PYRRXNDAL341WIN (Data source); Error number: 18452)



This happens randomly and when it does fail, I can either what for the next occurence in the schedule or I can start the agent manually and it completes successfully. I can also ping the other box when it happens. I've looked at the event logs and don't see anything going on around the times the distribution agent is having the problems.



Any suggestions on where to start looking for more detail?

[rmiao]

Did server lose domain controller at that time? Any related message in sql server log and windows event logs?

[bmckeen]

no, I do not see any errors in the event logs, application, system or security

[rmiao]

How about sql server log and sql agent error log?

[bmckeen]

nothing in either....the only error I get is the one in the original post from the distribution agent history.