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

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.


Resolution


1. Right Click on your database, choose properties
2. Goto the Options Page
3. In the Dropdown at right labeled "Compatibility Level" choose "SQL Server 2005(90)"
4. Goto the Files Page
5. Enter "sa" in the owner textbox.
6. Hit OK


---------------------
EXEC sp_dbcmptlevel 'yourDB', '90';goALTER AUTHORIZATION ON DATABASE::yourDB TO "yourLogin"gouse [yourDB]goEXECUTE AS USER = N'dbo' REVERTgo
---------------------


Comments

Author: Venkatesan Prabu .J25 Jun 2010 Member Level: Gold   Points : 1



I have written an article on this, do check it.



http://venkattechnicalblog.blogspot.com/2010/06/database-diagram-error-in-sql-server.html

cheers,

Venkatesan Prabu .J

Author: James Cook11 Mar 2011 Member Level: Bronze   Points : 1

Thanks Chirag, for the great answer. I had missed the bit about the files page when I read the error message.

Guest Author: arunima04 Aug 2012

thanks in case of sql 2008 in "OPTIOnS" Do we still enter sql server 2005 or 2008



  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name:
    Email: