Re: VS 2005 - Server Explorer - Diagrams - Invalid DBO User

From: Gail Erickson [MS] (gaile_at_online.microsoft.com)
Date: 11/08/05

  • Next message: Tibor Karaszi: "Re: Sql 2005 express edition information" 
    Date: Tue, 8 Nov 2005 10:45:26 -0800

    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 
news:upWOQKJ5FHA.2552@TK2MSFTNGP10.phx.gbl...
> 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" <tibor_please.no.email_karaszi@hotmail.nomail.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
>>>
>>>
>>>
>>
>
>
  • Next message: Tibor Karaszi: "Re: Sql 2005 express edition information"

    Relevant Pages

    • Re: Change dbo
      ... I have a database where a user is defined as the dbo on a database. ... I tried using SQL Server Manger ... The login for this person maps to dbo. ...
      (microsoft.public.sqlserver.security)
    • Re: VS 2005 - Server Explorer - Diagrams - Invalid DBO User
      ... 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. ... I dropped the user mapping for MyUser to MyDatabase and also ... dbo schema and db_owner role and I'm receiving the same error...... ...
      (microsoft.public.sqlserver.security)
    • Re: db_owner role in SQL 2k
      ... I do the select user_nameand get dbo ... Do you mean EM lists VDW as the owner of the database? ... I presume then that you are logged in as tfs. ... So my guess is that the login tfs is in the sysadmin role on the server, ...
      (microsoft.public.sqlserver.programming)
    • Re: Groups for dbo
      ... Thanks for the instructions on changing the database owner...I suspect ... While dbo is SUPPOSED to be a special user that's not used for routine ... It's probably safer to change the database owner in any event, ... >> I'm still fairly new to SQL Server, and I'm trying to figure something ...
      (microsoft.public.sqlserver.security)
    • Re: Change UDF Owner
      ... system_function_schema -especially in the master database. ... Most good judgment comes from experience. ... dbo is in the context of a database, and can be the schema owner for the ... Users can be put in the dbo role, ...
      (microsoft.public.sqlserver.security)
    • Quantcast