Re: VS 2005 - Server Explorer - Diagrams - Invalid DBO User
From: Lazer (Lazer_at_discussions.microsoft.com)
Date: Wed, 9 Nov 2005 08:44:23 -0800
YES I am having the same problam and by changing the compatibility level it
fixes the problem
The only problem with that is that my customers have not yet updated to SQL
2005 and I need the database to be in SQL 2000 compatibility level, and by
you saying that "you can always set it back to the orginal compatibility
Do you mean that I will be able to backup and restore this database back to
my customer after that?
And what about the database diagrams will thay get deleted?
"Gail Erickson [MS]" wrote:
> What's the compatibility mode of the database? If it's 80 or lower, you
> might try setting the compat mode to 90 and retrying. I read a post
> yesterday that indicated this might solve the problem. At least it wouldn't
> hurt to try - you can always set it back to the orginal compatibility level.
> Gail Erickson [MS]
> SQL Server Documentation Team
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Jay Douglas" <jayREMOVEIFNOTSPAM@jaydouglas.com> wrote in message
> > Tibor,
> > I'm pretty sure that you are correct about the orphaned user as this
> > deployment of the database was a backup from a different database.
> > However, I dropped the user mapping for MyUser to MyDatabase and also
> > removed the login. I recreated the login and user mapping for MyUser with
> > dbo schema and db_owner role and I'm receiving the same error......
> > Any further help is very appreciated. I can't find any answers in Google.
> > Thx again
> > --
> > Jay Douglas
> > http://www.jaydouglas.com
> > "Tibor Karaszi" <email@example.com> wrote
> > in message news:u%23TZ97I5FHA.884@TK2MSFTNGP14.phx.gbl...
> >> Orphaned database owner (check the SID for dbo user in the database and
> >> that such exists in master for the logins).?
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >> Blog: http://solidqualitylearning.com/blogs/tibor/
> >> "Jay Douglas" <jayREMOVEIFNOTSPAM@jaydouglas.com> wrote in message
> >> news:ug92V5I5FHA.2036@TK2MSFTNGP14.phx.gbl...
> >>> When attempting to edit diagrams in Server Explorer from Visual Studio
> >>> 2005 I receive the following error:
> >>> 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. Ensure the dbo account is valid and ensure that you have
> >>> impersonate permission on the dbo account.
> >>> I am not logged in w/ a user created user called MyUser. I set the
> >>> default schema to dbo for MyUser on MyDatabase. I also placed MyUser
> >>> has db_owner on MyDatabase.
> >>> What am I missing?
> >>> Thanks,
> >>> --
> >>> Jay Douglas
> >>> http://www.jaydouglas.com