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.

Ekrem Önsoy December 26, 2018 MSSQL

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:

Use MyDatabase
GO
EXEC sp_changedbowner 'sa'

Use MyDatabase

EXEC sp_changedbowner 'sa'

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.

ALTER AUTHORIZATION ON DATABASE::MyDatabase TO sa;

1	ALTER AUTHORIZATION ON DATABASE::MyDatabase TO sa;

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

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:

EXPLANATION:

SOLUTION:

About Ekrem Önsoy

Leave a Reply Cancel reply

Categories