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

9 Nov


This problem occurs (at least in our case) when a user which initially created the database have been deleted/deactivated through ldap – the database will be owned by an invalid user. This is what we did to solve it:

USE databasename

sp_changedbowner sa


Other articles on the same problem


Leave a Reply

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

You are commenting using your 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

%d bloggers like this: