Database Diagram error on SQL 2005

• manojkanoi

  SSCrazy

  Points: 2292

  More actions

  January 31, 2006 at 8:45 pm

  #168047

  I upgraded from SQL 2000 to SQL 2005. The database owner is sa and I am logging in as sa in Management Studio. But when I click on Database diagrams I get the following 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."

  How can I fix it?

• Steven-241105

  SSC Enthusiast

  Points: 181

  More actions

  February 2, 2006 at 5:29 am

  #618348

  Will be fixed in SP1.

  http://support.microsoft.com/default.aspx?scid=kb;en-us;910228

  http://www.issociate.de/board/post/274243/SQL_2005_Developers_Diagram_question.html

   

• manojkanoi

  SSCrazy

  Points: 2292

  More actions

  February 2, 2006 at 4:31 pm

  #618541

  Thanks. Using the second link fixed the problem.

• riversoft

  SSC-Addicted

  Points: 415

  More actions

  February 8, 2006 at 11:33 am

  #619594

  Thanks also.