Cannot add new Database Diagrams

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kai - 23 Dec 2005 04:39 GMT

Hi,
Use SQL Servere 2005 Express. I try to add new database diagram but I get
"This database doesn't have valid owner,...,Use ALTER AUTHENTICATION to
setup dbo to valid database owner...". I login as dbo, please help how to
resolve this .

Thanks

Kai

Reply to this Message

Michael Cheng [MSFT] - 23 Dec 2005 10:10 GMT

Hi Kai,

It seems dbo is not the owner of database base, please use ALTER
AUTHENTICATION to change the owner of database.

You may also try login as dbo and then try to create a new database, create
a new database diagram.

Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================

Signature

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message

kai - 23 Dec 2005 14:09 GMT

Michael ,

Thank you for your help.

I use Windows Authentication, and in SQL Server Query Analyzer, I enter

"SELECT CURRENT_USER"

the return user name is "dbo". I setup database role for "dbo" db_owner, it
still does not work. What should I do from here?

Thanks

Kai

> Hi Kai,
>
[quoted text clipped - 15 lines]
> This posting is provided "AS IS" with no warranties, and confers no
> rights.

Reply to this Message

Jasper Smith - 23 Dec 2005 17:35 GMT

Is this a new database or a copy of one from SQL2000? If it has been
restored/attached from SQL2000 you need to change the compatability level of
the database to 90 in order for diagrams to work.

EXEC sp_dbcmptlevel 'database name', '90'

Signature

HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com

> Hi,
> Use SQL Servere 2005 Express. I try to add new database diagram but I get
[quoted text clipped - 5 lines]
>
> Kai

Reply to this Message

kai - 23 Dec 2005 19:01 GMT

Jasper,
Thanks a lot, you are right.

Kai

> Is this a new database or a copy of one from SQL2000? If it has been
> restored/attached from SQL2000 you need to change the compatability level
[quoted text clipped - 11 lines]
>>
>> Kai

Reply to this Message