Welcome to McFunley.com Sign in | Join | Faq

Post Categories

Friends

Work / Projects

Articles

Archives

SQL Server 2005 Database Diagrams PSA

posted on Friday, December 23, 2005 4:37 PM by mcfunley

If you find yourself struggling with the following error message in SQL Server Management Studio 2005:
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.
And you are sure that the database does in fact have a valid owner, check the "Compatibility Level" on the Options page. Make sure this is set to "SQL Server 2005."


Comments

# re: SQL Server 2005 Database Diagrams PSA @ Friday, January 13, 2006 1:12 PM

Excellent Informaiton.

  Scott Dexter

# re: SQL Server 2005 Database Diagrams PSA @ Monday, January 23, 2006 7:45 PM

Thanks! That saved me a lot of messing about.

  Rob Lewis

# re: SQL Server 2005 Database Diagrams PSA @ Monday, January 30, 2006 12:02 PM

Thanks for the info!

  Burt

# re: SQL Server 2005 Database Diagrams PSA @ Saturday, February 04, 2006 7:58 AM

Any recommendations if a database still gives me the error after making this change? I have a couple other databases on the same instance that I performed this for and all issues were resolved, but for one I continue to run into the problem.

  Chip James

# re: SQL Server 2005 Database Diagrams PSA @ Tuesday, February 07, 2006 7:05 PM

I guess I'm not enough of an expert to say when it comes to that.

  Dan McKinley

# re: SQL Server 2005 Database Diagrams PSA @ Wednesday, February 08, 2006 11:29 AM

I need compatibility set to SQL 2000. Is there another way?

  Mike

# re: SQL Server 2005 Database Diagrams PSA @ Thursday, February 09, 2006 9:19 AM

If it still isn't working for you there might be one more step that I need to perform when I restore a database from a different Sql Server 2000 Server: Change the database login to a different owner, and then if you want, back to the original to fix a discrepency that is created in the system tables with dbo. Make sure that the login that you are giving ownership to does not exist as a user in the database you are changing the owner for when you do.

This *might* be happening because the database I restored from the other server had diagrams in it already; I haven't experimented to find the true cause yet. So if you find the time to figure out the particulars, please post - I'm curious.

  Ryan Riehle

# re: SQL Server 2005 Database Diagrams PSA @ Saturday, March 04, 2006 12:46 PM

Switch compatability to 90, click on digrams tab, install required objects, then set compatability to anything you like.

-j

  Jody

# re: SQL Server 2005 Database Diagrams PSA @ Thursday, April 27, 2006 4:31 PM

hi from Russia!
Very cool!! :))

thx!!

  calabonga

# re: SQL Server 2005 Database Diagrams PSA @ Friday, June 16, 2006 6:32 AM

I spent two hours yesterday... I'm disappointed I didn't find this earlier. You have helped a lot!

  Noah

# re: SQL Server 2005 Database Diagrams PSA @ Tuesday, October 03, 2006 5:00 AM

I need to disable comments on this post due to the amount of spam it's getting (I guess because it was posted to usenet). If anyone has questions you can email me directly.

  Dan McKinley

SKIN NAME : ImageHeader