Ch. 11 p. 377 Error when I try to Add New Diagram to my database

ceboc · November 4th, 2009, 03:38 AM

Hi,

I get an errror, when I try to Add New Diagram to my database in the Try It Out exercise on page 377.

The following happens:

1. I right-click the Database Diagrams element and click Add New Diagram.

2. A messagebox appear: "This database does not have a valid dbo user or you do not have permissions to impersonate the dbo user, so database diagramming is not available. Do you want to make yourself the dbo of this database in order to use database diagramming ?"

3. I answer Yes

4. A messagebox: "This server does not have one or more of the database objects required to use database diagramming. Do you wish to create them ?"

5. I answer Yes

6. A messagebox: "Could not obtain information about Windows NT group/user 'Netcom\Bo' error code 0x534."

I have not heard about 'Netcom' before. 'Bo' is my username on the computer.

How do I Add New Diagram to the database correctly ?

Thanks

Bo

Imar · November 4th, 2009, 04:06 AM

Hi there,

You may want to take a look here: http://forums.asp.net/p/1455322/3408820.aspx and follow the links in that thread. There could be a number of reasons for this issue, so you'll need to find out what applies to you...

Cheers,

Imar

ceboc · November 4th, 2009, 07:52 AM

Hi

I am sorry but the link did not help me.

Do you or someone else have any idea what I must do ?

Best regards,
Bo

Imar · November 4th, 2009, 09:01 AM

It sounds like a configuration / security issue to me. Difficult to track down remotely...

Can you provide more information about your setup? Version of SQL Server, the account you log on to your system with (domain or local), the permissions set on the App_Data folder, the account that SQL Server uses.

Also, try installing the SQL Server Management Studio Express and look at your database. Make sure it has a valid DBO and check, under Security, the permissions.

Hopefully, by supplying more info we can track this down.

Cheers,

Imar