When I click on the Database Diagram node in Sql Server 2005, I get an error message that tells me the databse object cannot be installed.

I just loaded Sql Server 2005 Developer Edition onto my server to help with developing ADO.Net apps. I tried to creat a diagram using a couple of related tables but I got an error message: "Database objects cannot be installed because the database does not have a valid owner". I never had to do this with Sql server 2000 to create my diagrams. What do I need to install to make some diagrams?

Thanks
grouchyfdAsked:
Who is Participating?
 
ShogunWadeConnect With a Mentor Commented:
ok.  now change the database owner to sa
0
 
ShogunWadeCommented:
The database was probably a sql 2000 database i guess?     Check the database compatibility level in database properties.    it must be set to 9.0 or you cant create diagrams.
0
 
grouchyfdAuthor Commented:
I can't seem to locate any thing like this in the properties windows of the database. The rest of the message is:
"To continue, first use the Files page of the Database Properties box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."  When I open the Files page, database owner is listed as (my server name)\Administrator. I also have it set up with Windows Authentication so I wouldn't have to login to the server all the time.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
ShogunWadeCommented:
dont worry about the detail of the error message ,it's misleading.

from SQL Server MAnagement Studio:
right click the database and click properties,   from there on the left hand side click on "Options".   the screen shows a field called "Compatability level"  change this to SQl Server 2005 (90).

0
 
grouchyfdAuthor Commented:
I found the compatability level and changed it to Sql Server 2005 (90). I restarted the the server and I still get the same message when I try to make a diagram.
0
 
grouchyfdAuthor Commented:
Thank you ShogunWade for your help and expertise. That got it. I know enough SQL Server to get me in trouble, but I need it for my app. development.
0
 
ShogunWadeCommented:
Youre welcome
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.