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.

Categories:

change the owner of your database, this case occurs when you restore the database from server where different users available other than sa and same user doesn’t exists in your server. use the following command in sql query window

EXEC sp_changedbowner ‘sa’

Leave a Reply

Your email address will not be published. Required fields are marked *