SQL Server Performance

Replication Problems - help

Discussion in 'SQL Server 2005 Replication' started by sql_jr, Apr 19, 2007.

  1. sql_jr New Member

    The Queue Reader Agent has encounted the error "Login failed for user 'myrepl'"<br /><br />What does this mean? Where do I configure this?<br /><br />Also, I get in Distributor to Subscriber history monitor log:<br /><br />Could not find a valid Agent Id for the subscription to Publisher MyPublisher, database MyDB, publication MyPub. (Source: MSSQLServer, Error number: 2175<img src='/community/emoticons/emotion-11.gif' alt='8)' /><br /><br />HELP! TIA!<br /><br /><br />
  2. MohammedU New Member

    Looks like it is authentication issue.
    Make sure Myrepl log is working and it has the proper access.


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page