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.


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

Share This Page