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: 275
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