ict.ken.be

Delivering solid user friendly software solutions since the dawn of time.

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

Categories: SQL Server

Microsoft SQL Server Management Studio
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.

Solution:

  1. Right Click on your database, choose properties
  2. Goto the Files
  3. Change the owner textbox to "sa"
  4. Press OK