Replication Problems – help | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Replication Problems – help

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 />
Looks like it is authentication issue.
Make sure Myrepl log is working and it has the proper access.
Moderator All postings are provided “AS IS” with no warranties for accuracy.