Geeks With Blogs
John Haigh's Blog
In SQL 2005, if you get this message when trying to create a new Database Diagram:

"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."

Here are the sql statements to resolve this:

EXEC sp_dbcmptlevel 'yourdatabasename', '90';
go
ALTER AUTHORIZATION ON DATABASE::
yourdatabasename TO "dbusername"
go
use [
yourdatabasename]
go
EXECUTE AS USER = N'dbo' REVERT
go
Posted on Wednesday, October 1, 2008 9:15 AM SQL | Back to top


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

# re: Database diagram support objects cannot be installed because this database does not have a valid owner
Requesting Gravatar...
Thanks John. Thery useful tip!!
P.S. i replaced "dbusername" with "sa"
Left by Paolo Cavaliere on Dec 27, 2009 5:53 AM

# re: Database diagram support objects cannot be installed because this database does not have a valid owner
Requesting Gravatar...
Thank you very much for ur help. i am very appriciate that,
Left by Madhushan on May 02, 2011 12:56 PM

Your comment:
 (will show your gravatar)


Copyright © John Haigh | Powered by: GeeksWithBlogs.net