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.
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
]]>