Replication Issue – 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.

Issue – Replication Log Reader agent was failing with below error messages.

2018-04-24 19:33:07.854 Status: 32768, code: 53044, text: ‘Validating publisher’.

2018-04-24 19:33:07.873 Status: 4096, code: 20024, text: ‘Initializing’.

2018-04-24 19:33:07.873 The agent is running. Use Replication Monitor to view the details of this agent session.

2018-04-24 19:33:07.879 Status: 0, code: 20011, text: ‘The process could not execute ‘sp_replcmds’ on ‘xxx’.’.

2018-04-24 19:33:07.879 The process could not execute ‘sp_replcmds’ on ‘xxx’.

2018-04-24 19:33:07.879 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.’.

2018-04-24 19:33:07.879 Status: 0, code: 22037, text: ‘The process could not execute ‘sp_replcmds’ on ‘xxx’.

Resolution – In order to resolve the issue; please ensure database owner is valid.

In my case Publication database was not having owner assigned but this issue might occur if owner is not valid

e.g. user as owner and his domain account is disabled

disabled sql user

repl1

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s