SQL Server 2005 Acting Up (not a valid dbo).

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: ayende@xxxxxxxxx
Date: 27 Nov 2005 02:13:53 -0800

Visual Studio gives me the following two messages whenever I open it:

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. Do you want to make yourself the dbo of this database in
order to use database diagramming?

And then:

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 you have
impersonate permission on the dbo account.

I'm administrator on the box, and I dropped and recreated all the
databases, but I can't get it to work.
Any ideas?

.

Prev by Date: Re: OleDbDataAdapter vs OleDbCommand
Next by Date: Re: Software for Windows and Mac
Previous by thread: Re: coding pop up boxes in ASP.Net
Next by thread: Help Required for Help Context Id !!!!!!
Index(es):
- Date
- Thread

Relevant Pages

Re: Orphaned user owns objects as dbo and cannot be dropped.
... So I had to directly update the dbo.sysobjects system table to chane the uid ... How can I get rid of this use name in this database? ... SQL server to the production server. ... the database dbo user is ...
(microsoft.public.sqlserver.security)
Re: Orphaned user owns objects as dbo and cannot be dropped.
... SQL Server MVP ... "Dan Guzman" wrote: ... How can I get rid of this use name in this database? ... the database dbo user is ...
(microsoft.public.sqlserver.security)
Re: Orphaned user owns objects as dbo and cannot be dropped.
... How can I get rid of this use name in this database? ... I suspect this is a different problem than the database owner. ... SQL server to the production server. ... the database dbo user is ...
(microsoft.public.sqlserver.security)
Re: dbo association
... looked and dbo is the sa login in the master database. ... Well anyway seemes to work for now (I hope sql errors ... >mapping for the dbo user. ... >EXEC sp_changedbowner 'MyLogin' ...
(microsoft.public.sqlserver.security)
VS 2005 - Server Explorer - Diagrams - Invalid DBO User
... This database does not have a valid dbo user or you do not have permissions ...
(microsoft.public.sqlserver.security)