Wednesday, March 7, 2012

Can't create database diagrams

Hello, I'm using C# express with SQL express.

I can create a database, create tables and I can even delete the database but I cannot create database digrams. I get an error that says I don't have a valid dbo user or permissions to impersonate. It asks me if I would like to impersonate but it just fails. Any Ideas? Thanks

In this case the first course is to consider that the error might be telling you exactly what the problem is. Does the account you're logging into the server with have dbo rights?

Another idea may be that your database doesn't have a valid owner, check out the post at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=120849&SiteID=1 for a discussion about this issue.

Regards,

Mike Wachal
SQL Express team

-
Please mark your thread as Answered when you get your solution.

No comments:

Post a Comment