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.

 

ERROR:

“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.”

EXPLANATION:

For various reasons, the owner of a database may be deleted or empty. Such an error message may be encountered when there is no owner of a database.

SOLUTION:

You can skip this error if you have a valid owner of the database.

You can use the following command to change the owner of a database:

You can do this with the above script, but the microsfot announces that sp_changedbowner will be removed. Instead, it recommends using the following script.

Ekrem Önsoy
Author: Ekrem Önsoy

The original article was written in Turkish by Ekrem Önsoy and translated to English by dbtut with the consent of the author. The copyright of the article belongs to the author. The author shall not be liable in any way for any defect caused by translation.

Leave a Reply

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