VS 2005 - Server Explorer - Diagrams - Invalid DBO User

From: Jay Douglas (jayREMOVEIFNOTSPAM_at_jaydouglas.com)
Date: 11/08/05 

Date: Tue, 8 Nov 2005 11:07:52 -0700

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

Relevant Pages

  • Re: Reconnecting Orpahan Users
    ... This means the user 'SA' is the not the database owner in the source ... Due to this reason dbo user also become orphan. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL2005 FT error adding table column
    ... sysconstraints dbo view ... ad_banners dbo user table ... PK_ad_banners dbo primary key cns ...
    (microsoft.public.sqlserver.fulltext)
  • Re: xp_logevent and service broker queues
    ... With EXECUTE AS OWNER 'dbo', the database owner of your user database needs to be 'sa' in order for the security context to be 'sa' in master too. ... This queue receives all messages and starts the stored procedure sp_AsyncReceive which is owned by the dbo. ... Maybe somebody can give me a hint how to call 'sysadmin' functions under the dbo user or how to change permissions for calling these functions in a stored procedure which is started by a service broker queue. ...
    (microsoft.public.sqlserver.security)
  • Re: xp_logevent and service broker queues
    ... With EXECUTE AS OWNER 'dbo', the database owner of your user database needs to be 'sa' in order for the security context to be 'sa' in master too. ... Maybe somebody can give me a hint how to call 'sysadmin' functions under the dbo user or how to change permissions for calling these functions in a stored procedure which is started by a service broker queue. ...
    (microsoft.public.sqlserver.security)
  • Re: dbo question
    ... When I look at the dbo user for a database in EM, ... The cases where EM doesn't show a login name, seems to be the ones where the ... dbo isn't mapped to a login name that has been created as a login in SQL ...
    (microsoft.public.sqlserver.server)
Quantcast