Post reply

Replication Issue

  • April 13, 2012 at 5:17 am

    #254082

    Hi all I am receiving the following error after setting up a local test transactional publication and subscription:

    2012-04-13 10:58:41.671 Status: 4096, code: 20024, text: 'Initializing'.

    2012-04-13 10:58:41.671 The agent is running. Use Replication Monitor to view the details of this agent session.

    2012-04-13 10:58:41.677 Status: 0, code: 20011, text: 'The process could not execute 'sp_replcmds' on 'HALLW2678'.'.

    2012-04-13 10:58:41.677 The process could not execute 'sp_replcmds' on 'HALLW2678'.

    2012-04-13 10:58:41.677 Status: 0, code: 15517, text: '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.'.

    2012-04-13 10:58:41.677 Status: 0, code: 22037, text: 'The process could not execute 'sp_replcmds' on 'HALLW2678'.'.

    I am unsure what permissions could be wrong. I have changed the agents, and the connections to the subscription and distribution to be my windows account that has SA, also the owner of the the publichser and subscriber DBs are my account. The only thing I can see is the Distribution being owned by SA.

    Any ideas?

    Thanks

  • April 13, 2012 at 6:01 am

    #1473168

    Ok I found the answer here

    http://stackoverflow.com/questions/2723061/sql-server-2008-replication-failing-with-process-could-not-execute-sp-replcmds

    However my owners were not null in my case but had my account as an owner. I had already used sp_changedbowner previously in trying to fix this. If anyone is able to explain why the ALTER AUTHORIZATION ON DATABASE::[<dbname>] TO [xxx\xxx] worked and sp_changedbowner did not I would be interested to know?

    Thanks

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply