sql server 2005 diagram support

[wsyeager]

For some reason, when I try to access a database diagram on our new 2005 SQL Server, I get the following error msg:

 

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

 

It then goes on to instruct me to either use Properties > Files or ALTER AUTHORIZATION to change the database owner.

 

Well, I've done that - and it clearly shows that there is an owner of the database, but even if I log in as that owner, the error msg continues to come up everytime I try to access Diagrams.

 

 

I found a post to run the following stored procedure which will set the sql server compatability level:

 

EXEC sp_dbcmptlevel database_name, 90

 

After running that in the query window of Management Stduio, I get the following msg below on the Messages tab:

 

"DBCC execution completed. If DBCC printed error messages, contact your system administrator."

 

I then try to create a new diagram again, and I get the same initial error (at the top of this post).

 

What do I need to do in order to create a DB diagram?

[Nerseus]

I tried this as well. At first, I got the same error as you. I used the GUI to change the compatability to 90 (right-click the DB, select Properties, go to the Options tab, Compatability Level).

I then disconnected my server from the MAnagement Studio and reconnected. Now when I open Database Diagrams it says something about the objects aren't there, do I want to create them. I said Yes and all works well.

 

-ner

[wsyeager]

After even going into the options and setting the Compatability level to 90, I detached and then reattached the db.

 

I even took it offline, then back again online.

 

I am still getting the same error msg.....

 

What do I need to do just to be able to use the Diagram support?

 

This is so frustating.....

 

:mad:

[Puiu]

I did as Nerseus said and i still got the same error.

 

the owner set for my database was the windows administrator and that seemed to be the problem. I switched the owner to sa, i reconnected and it worked!

 

However if i try to set the owner back to Computer\Administrator it gives me an error:

 

The proposed new database owner PUIUALEX\Administrator is mapped as user PUIUALEX\Administrator in this database.

Parameter name: PUIUALEX\Administrator

 

My guess: I don't have a login associated with this user....but i'm not sure :)