locked
SQL Replication Log Reader agent error "Executed as user: Domain\XXX_LRAgent. A required privilege is not held by the client. The step failed. RRS feed

  • Question

  • I am trying to configure transactional replication between two server. When I created the publication, I could see that the agent job was in failed state with the error "Executed as user: Domain\XXX_LRAgent. A required privilege is not held by the client.  The step failed.

    User account has 'db_owner' privilege on the publisher & distributer database. This account also has 'Log on as a Service' access. 

    From Sql error log


    Message
    Replication-Replication Transaction-Log Reader Subsystem: agent xxxx_xxx-2 failed. Executed as user: Domain\xxx_LRAgent. A required privilege is not held by the client.  The step failed.

    Error: 14151, Severity: 18, State: 1. 

    Please help. 

    Friday, December 11, 2020 7:50 AM

All replies