Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Can anyone show me the way to fix these error messages:

The process could not execute 'sp_replcmds' on 'S15415940'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20011)

Cannot execute as the database principal because the principal "dbo" does not exist, this type of principal cannot be impersonated, or you do not have permission. (Source: MSSQLServer, Error number: 15517)

The process could not execute 'sp_replcmds' on 'S15415940'. (Source: MSSQL_REPL, Error number: MSSQL_REPL22037)

Thanks you!

share|improve this question

1 Answer 1

In my experience I had this message

The process could not execute 'sp_replcmds'

when two log reader processes where accidently trying to run.

The fix I had was to: connect at the publisher, look in master..sysprocesses for a a leftover process from the distributor kill it, and relaunch the log reader on the distributor.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.