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.
Error: 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. Fixed this error with the help of this article : http://stackoverflow.com/questions/2043382/database-diagram-support-objects-cannot-be-installed-no-valid-owner In SQL Server Management Studio do the following: Right Click on your database, choose properties Go to the Options Page In the Drop down at right labeled "Compatibility Level" choose "SQL Server 2005(90)" 3-1. choose "SQL Server 2008" if you receive a comparability error. Go to the Files Page Enter "sa" in the owner textbox. 5-1 or click on the ellipses(...) and choose a rightful owner. Hit OK after doing this, You will now be able to access the Database Diagrams...