Sql-server – MS SQL 2008 – Transactional Publication failure – The process could not execute ‘sp_replcmds’ on ‘SERVERNAME’

sql server

I got MS SQL 2008 running on Windows Server 2008 R2.

Everything is fresh install running on a VM.

I can make a Snapshot Publication without problems. But I am unable to make a Transactional Publication, I get errors even before I try to configure a subscriber. Here's how I did things:

  1. I configure Distribution. (DEFAULT SETTINGS)

  2. I start the New Publication Wizard.

    • Transactional publication
    • I select "Creat a snapshot immediately"
    • I configure the security settings for the Snapshot Agent and Log Reader Agent (Using the Windows account Domain Admin)
    • The Publication is created succesfully, no errors.
    • The "View Snapshot Agent Status" report no errors – 100% success.
    • Going to the Replication Monitor, that's where the errors begin – Error with the Log Reader Agent – "The process could not execute 'sp_replcmds' on 'SERVERNAME'…" [see picture]

What am I doing wrong? Or what am I missing?
enter image description here

Best Answer

From BOL:

Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_replcmds.

So, who is the logreader agent running as? That is, how is it connecting to your publisher database? If that user doesn't have db_owner or is a sysadmin, you'll get a failure.

Related Topic