sql server 2005 diagram support

W

wsyeager

Well-known member
Joined
Apr 10, 2003
Messages
140
Location
Weston, FL
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, Ive 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?
 
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 arent there, do I want to create them. I said Yes and all works well.

-ner
 
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:
 
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 dont have a login associated with this user....but im not sure :)
 
Back
Top