SQL Server Performance

Replication Error !! Urgent Help

Discussion in 'Performance Tuning for SQL Server Replication' started by gk_sql, Mar 22, 2007.

  1. gk_sql New Member

    Hi,

    I have the transactional replication configured on one of my server. Subscriber is also on the same server. Server is rebooted and after that iam getting the following error.

    "SQL Server Agent could not access the replication agent. Use the DCOMCNFG utility to confirm that the SQL Server Agent Windows account has permissions to launch the replication agent. The step failed"

    I dont have a box access on the server also,

    Could any body help me on this.


    Thanks
    GK
  2. MohammedU New Member

    It could be related to MSDTC permission issue...
    Did you guys applied any OS patches or Service packs befor reboot?

    Check MSDTS is running..

    MohammedU.
    Moderator
    SQL-Server-Performance.com
  3. Jon M Member

    What's your current SQL Server service pack?

    Read this: http://support.microsoft.com/kb/q299539/

    Jon M

Share This Page