The process could not execute 'sp_replcmds' on 'database_name'

Question

I got an error message in my Log Reader Agent:

The process could not execute 'sp_replcmds' on 'Database Name'.

I created another agent profile with a large query timeout and a min value to batch, but it still doesn't work.

Can someone help me?

I'm using SQL Server 2008 and I'm trying to do a replication between databases on different servers.

Answer 1

It could be possible that owner of the database could be someone other than what you have permissions for. Below there's a simple command to change ownership...if you have the rights to do so.

--TSQL Code--
USE PublishedDatabase
GO
EXEC sp_changedbowner 'sa'
GO

Answer 2

This could be due to Owner is not set for the database.

You can check by right clicking on database then choose Property and go to File Table and the Owner selection should be there.