Trying to See My Database Diagram

[mickeyj2]

Hi,
I'm running through a SQL Server book for SQL Server 2005.

To work with many of the features, I downloaded a copy of the "AdventureWorks" sample database.

One of the objects with AdventureWorks is the Database Diagram.

Whenever I click on it, I get the following error information:
"Database diagram support objects cannot be installed because this database does not have a valid ownder. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statemetn to set the database owner to a valid login, then add the database diagram support objects."

When I goto AdventureWorks Database properties and click on the Files page, I see that the owner is my login that I've used to get into the database, my DOMAIN_NAME\user ID.

What am I doing incorrectly? Also it mentioned the Alter Authorization statement. Is that what I need to do? I thought about adding my DOMAIN_NAME\user as a valid user for this database to see if that would fix the problem.

Thanks in advance for your help.

 

[mickeyj2]

I figured out what the problem was. I went to my database's File Properties and changed the user to NT AUTHORITY\SYSTEM, then built the Database Diagram objects, and finally added the appropriate tables to the database diagram.

I'm not sure what all the user NT AUTHORITY\SYSTEM is allowed to do, but I'm sure it has to do with the Windows Authentication process, and since I was already logged in as a Windows systems-authenticated user, this seems to have done the trick.

Hope this helps someone out.