SQL Server 2008 replication failing with: process could not execute 'sp_replcmds'

sql-server-2008 replication
skb picture skb · Apr 27, 2010 · Viewed 57k times · Source

I have an issue with SQL replication that I am having trouble fixing. What I am doing is restoring two DBs from a production backup, and then installing replication between them. The replication seems to be configured without any errors, but when I look at the status I see error messages like this:

Error messages:

The process could not execute 'sp_replcmds' on 'MYSERVER1'. 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 not execute 'sp_replcmds' on 'MYSERVER1'. Get help: http://help/MSSQL_REPL22037

What does this mean?

Answer

Mattias Nordqvist picture Mattias Nordqvist · May 30, 2012

When I had this problem, my database didn't have an owner set properly. I had restored a database from another windows domain, right clicked the database -> properties and verified in the "general" tab that the owner was set correctly. However, in the "files" tab, owner was not set at all. As soon as I set it, replication was running without problems.

Related questions

How do I check SQL replication status via T-SQL?

I want to be able to check the status of a publication and subscription in SQL Server 2008 T-SQL. I want to be able to determine if its okay, when was the last successful, sync, etc.. Is this possible?

Read More
Guide for Replication in MS SQL Server 2008

I wonder if anyone know/have a good guide for Replication in MS SQL Server 2008? I want to set up a Replication between two different computers that run MS SQL Server 2008, the master runs on Windows Vista, and the slave …

Read More
Length of LOB data (78862) to be replicated exceeds configured maximum 65536

Here is a related question. Why do I get this error even when I have not installed SQL Server replication ? The strangest thing is, when I run the fix sp_configure 'max text repl size', 2147483647 Go RECONFIGURE GO it works …

Read More