Skip to main content

Posts

Showing posts from November, 2010

The process could not execute 'sp_replcmds' on

Today I ran in to a bit of a bizarre error message when setting up replication.   After initializing the subscription I tried starting the log reader agent, but it never wanted to start. It kept on telling me that “The process could not execute 'sp_replcmds'” could not be executed. I opened replication monitor for a closer look at the error message, after going through the details of the log reader agent i was surprised to find three messages. Following are the messages as they were listed on the agent history. ·           The process could not execute 'sp_replcmds' on 'SQL\LAB01' . (Source: MSSQL_REPL, Error number: MSSQL_REPL20011) Get help: http://help/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) Get help: http://help/15517 ·           The process could n