What would cause SQL 2008 Log Reader Agent to fail with "This process could not execute 'sp_replcmds

Posted by Rick on Server Fault See other posts from Server Fault or by Rick
Published on 2010-06-10T23:12:25Z Indexed on 2010/06/10 23:24 UTC
Read the original article Hit count: 246

I've seen this error message in other posts. They didn't seem to help resolving our issue. We are trying this with two SQL Server 2008 servers. I backed up my database from the source server and then restored it on our destination server. We setup basic Transaction Replication. The Snapshot Agent is working fine. The Log Reader Agent fails with the error above. Is it most likely a login issue for this job or QueryTimeout?

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about database-replication