EM when creating DB diagram in IDE : no valid dbo user

Hello all,

I created a DB in support of my C# application. but when I try to create a relationship between 2 tables in my IDE. I get following EM

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

I select yes and get following EM

"This database does not have a valid dbo user or you do not have permissions to impersonate the dbo user,so db diagramming is not available. Ensure that the dbo is valid and ensure you have impersonate permissions on the dbo account. "

PS: i'm a noobie...

Thanks in advance for your help.

Visual Studio Express Editions43

Hello all,

Got a solution:

I had the same problem. My laptop is joined to a domain, and I was working offline. As soon as I connected back to my domain with VPN it starter working again.

Indeed this solves the issue..

Thanks

Bye

give me answer plz

I don't have the solution, but I think I have the cause.

Are you working with a laptop or computer that connects and disconnects to a company domain

And this occurs when you are trying to create a Database Diagram while following along with "Absolute Beginner’s Video Series"

I bet you downloaded C# Express or VB Express and the video series at work - but like any good employee - you went home to watch the videos and start programming.

I think the problem is the dbo (data base owner) user name gets stored with the database when you create it in C# Express. Or maybe the dbo user is set when you first install C# or VB Express Edition.

I installed both VB and C# Express right after I downloaded both while at work - onto my laptop - while connected to the company network. So my dbo user name is "SOME_COMPANY_DOMAINNAME/user_name". But when I run C# or VB at home - I log in as to Windows as plain "user_name". So at home I can not get the Database Diagrams function to work because I am now "user_name" and it's looking for "SOME_COMPANY_DOMAINNAME/user_name"!

In C# I right click on the database in the Database Explorer and select "Modify Connection". I see there that "Use Windows Authentication" is selected. And when I click on the database (in this case it's rss.mdf since I'm following the video series to create the RSSReader application), and look at the properties, near the bottom it shows the "Owner" as "SOME_COMPANY_DOMAINNAME/user_name".

The strange thing is when I'm at home, and not connected to the company network, and logged in as "user_name", I can still establish a connection to the rss.mdf database - I just can't create a Database Diagram!!

So somebody tell us how we can change the dbo user name or allow us to create the Database Diagram that is asked for as part of "Absolute Beginner’s Video Series" ! Because we are "absolute beginners" and we would like to become proficient C# programmers someday.

I am using Visual Basic 2005 Express but I think this is the same problem. I had this same issue. After searching this forum I had the cues I needed to correct the issue but none of the suggested methods worked. I think the problem stemed from the fact that I had renamed the primary windows user account to my name (the original Owner account left from the factory OS install). In the folder structure some of the folders were still titled "Owner" but further down the tree the new name was used. So this account was previously "Owner" but had been changed to my name. The solution was the create a new Windows account, all of the folders had the new name associated with them. Then I recreated the database and the problem accessing the database diagram didn't reoccur. I hope this helps.