When attempting to create a database diagram I get the following error:
Cannot execute as the database principal because the principal "dbo" does not exist
How do I fix this error?
This error occurs when the database owner for the files setting in the database properties is unassigned (or blank).
To fix this:
Properties
.Files
from the left hand navigation menu of the Database Properties
dialog box.sa
in the owner
field.OK
This gives the sa
permission to create files on the server.
You can also run this query to do the same thing:
EXEC sp_changedbowner 'sa';