Cannot create database diagram

onecurlyfry · December 14th, 2008, 07:31 PM

Hey Imar,

I'm plugging away, on chapter 11 of your ASP.NET book and loving every minute of it.

I'm attempting the Try it Out on page 377. Step 1 talks about how I may be prompted to make me the owner of the database. After clicking Yes twice, as prompted, I get the following error message:

Could not obtain information about Windows NT group/user '[domain/user name omitted]', error code 0x54b.

I am on my company computer, as a local administrator. I've tried google searching this, but have come up empty. Do you have any thoughts?

Thank you,

Scott

Imar · December 15th, 2008, 03:30 AM

Comes up empty?

http://search.live.com/results.aspx?...form=QBLH&qs=n

There seem to be some useful results in there, including

http://www.geekproject.com/archive.a...r=2007&Month=6

Haven't seen this error myself, so you'll need to test out a few results and suggestions to make this work....

Cheers

Imar

onecurlyfry · December 15th, 2008, 12:26 PM

Well that was easy.

I had google searched the error, and went through the first 7 or 8 pages, and saw a bunch of technical SQL jargon, so just moved on.

I have since gone back into many of those threads and at some point on the page saw "....if the machine is not connected to the domain..."

My desktop is a picture of Bart Simpson writing on a chalkboard over and over:

"I will use google before asking dumb questions"

Perhaps I should follow his advice :)

Thanks Imar :)

Imar · December 15th, 2008, 02:05 PM

Haha, funny..... Glad it's all working now...

Imar

allan_ravn · February 21st, 2009, 11:41 AM

Just wanted to add - (in case you are real newbie like me) that the following SQL query worked for me:

Just go to either Review or Genre in the database explorer, right click on either and chose "show table data". In the "SQL pane" I added the following (please correct this to fit your database location on your own computer).

ALTER AUTHORIZATION ON DATABASE ::[C:\Documents and Settings\Allan\Dokumenter\Visual Studio 2008\WebSites\MinWebsite\App_Data\PlanetWrox.mdf] TO [sa];

And then just press the "Execute SQL statement".

ihussey · April 7th, 2009, 04:23 AM

thanks for that - I had exactly the same problem - all fixed now