Database diagram support objects cannot be installed because this database does not have a valid owner – Error

When you try to create a Database Diagram and your database doesn't have a valid owner, you will receive the following error:

database_diagram_support_object_cannot_be_installed

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

It can happen when account that was the owner of the database was removed from the system, leaving the database with no owner, or if the database owner name is not a valid login in the SQL Server instance where you have attached or restored the database.

To fix the problem, change the owner of the database using the following code:

For example:

USE DBName
EXEC sp_changedbowner 'Login_Name'

or:

ALTER AUTHORIZATION ON DATABASE::Database_Name TO "Login_Name"
GO

To change the database owner using SQL Server Management Studio, right click on the database, choose ‘Properties’ and on the ‘Files’ tab in the ‘Owner’ field enter the new owner:

database_no_owner

Click 'OK' to confirm.

If the post helped you, please share it:
Pin It

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">