Thursday, July 19, 2012

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.

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.

I encountered the message while removing subscription in replication

1) We need to verify the owner of the database
2) If owner is null then assign 'sa', otherwise assign any domain user which has admin permission on the database.
3) Delete the subscription

No comments: