Re: Cached Credentials & Database Diagrams
- From: "Jasper Smith" <jasper_smith9@xxxxxxxxxxx>
- Date: Sat, 21 Jan 2006 01:04:09 -0000
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CC587FF8-AB0A-4464-A8AD-79F336B89B0F@xxxxxxxxxxxxxxxx
> 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!!
>
.
- Prev by Date: Re: SQL Server 2005 AND Security (Please Help)
- Next by Date: Re: Is it possible to sql inject this code?
- Previous by thread: Setting up and securing SQL Express in a (potentially) hostile environment
- Next by thread: How to add the web server logon
- Index(es):
Relevant Pages
|
|
