SQL Server 2008 R2 Replication log reader could not execute sp_replcmds

Posted by user49352 on Server Fault See other posts from Server Fault or by user49352
Published on 2012-08-06T19:24:52Z Indexed on 2014/06/08 21:28 UTC
Read the original article Hit count: 244

This log reader agent worked perfectly for several months until the user referenced in the error was removed from the domain. After that time the error 'The process could not execute 'sp_replcmds' on 'SERVER'' was received with more detail 'Could not obtain information about Windows NT group/user' that referenced said user.

This user was referenced nowhere in the the log reader agent other than the Publication Access List from which it was subsequenctly removed. The agent would still not successfully start up.

The simple problem here, I believe, is that the log reader agent was created under that user and that no longer exists in the domain. Is there an 'owner' somewhere that needs to be changed?

Every other function on the database continues to execute successfully. Any other help or thought would be appreciated.

© Server Fault or respective owner

Related posts about sql-server-2008-r2

Related posts about database-replication