Cached Credentials & Database Diagrams

My Environment:
Laptop, Windows XP Prof., Member of a Domain.
SQL Server 2000 and SQL Server 2005 Express.
SQL Server Logon = Windows
Database dbo = my account (DOMAIN\USER).
Problem:
Am unable to to access/use datbase diagrams in SQL Server 2005 - tells me
that dbo is an invalid account in the following circumstances:
New database created in 2005: When not connected to network (i.e. logged on
to windows using cached credentials and no domain controller accessible).
Attached SQL 2000 database: ALWAYS - i.e. get the error whether connected to
network or not, and am completley unable to expand/access diagrams.
This makes VS2005 web express completely unusable for me.
Problem is compounded by failure of all sql 2005 help files to display pages
(only the contents tree is visible).
Help!!For attached 2000 databases you need to change the compatability mode to 90
in order for diagrams to work
EXEC sp_dbcmptlevel 'database name', '90'
For the other issue you could try changing the owner of the database to sa
and see if that helps. Within your database run
exec sp_changedbowner 'sa'
or
alter authorization on database::[databasename] to [sa]
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
"John F" <JohnF@.discussions.microsoft.com> wrote in message
news:CC587FF8-AB0A-4464-A8AD-79F336B89B0F@.microsoft.com...
> My Environment:
> Laptop, Windows XP Prof., Member of a Domain.
> SQL Server 2000 and SQL Server 2005 Express.
> SQL Server Logon = Windows
> Database dbo = my account (DOMAIN\USER).
> Problem:
> Am unable to to access/use datbase diagrams in SQL Server 2005 - tells me
> that dbo is an invalid account in the following circumstances:
> New database created in 2005: When not connected to network (i.e. logged
> on
> to windows using cached credentials and no domain controller accessible).
> Attached SQL 2000 database: ALWAYS - i.e. get the error whether connected
> to
> network or not, and am completley unable to expand/access diagrams.
> This makes VS2005 web express completely unusable for me.
> Problem is compounded by failure of all sql 2005 help files to display
> pages
> (only the contents tree is visible).
> Help!!
>|||Thanks for a clear and concise answer. Both suggestions work.
John
"Jasper Smith" wrote:

> For attached 2000 databases you need to change the compatability mode to 9
0
> in order for diagrams to work
> EXEC sp_dbcmptlevel 'database name', '90'
> For the other issue you could try changing the owner of the database to sa
> and see if that helps. Within your database run
> exec sp_changedbowner 'sa'
> or
> alter authorization on database::[databasename] to [sa]
> --
> HTH,
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
>
> "John F" <JohnF@.discussions.microsoft.com> wrote in message
> news:CC587FF8-AB0A-4464-A8AD-79F336B89B0F@.microsoft.com...
>
>