Cannot create diagrams in SQLSERVER 2005

24 Jan 2006 1:04 AM

Juan Dent

Hi,

Every time I click on the Database Diagram node in object explorer in SQL
Server Management Studio, I get a message:

Database diagram support objects cannot be installed because this database
does not have a valid owner. ...

I have checked the owner and it coincides with my logon name in my domain
(i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
problem with Active Directory? Why am I not being recognized as a valid db
owner?

--
Thanks in advance,

Juan Dent, M.Sc.

24 Jan 2006 1:34 AM

Sue Hoegemeier

Make sure the compatibility level of the databases is set to
90 - that's often what causes the problem.
You can set it to 90 using:
EXEC sp_dbcmptlevel 'database name', '90'

-Sue

On Mon, 23 Jan 2006 17:04:01 -0800, Juan Dent
<Juan_Dent@nospam.nospam> wrote:

Show quote

>Hi,
>
>Every time I click on the Database Diagram node in object explorer in SQL
>Server Management Studio, I get a message:
>
> Database diagram support objects cannot be installed because this database
>does not have a valid owner. ...
>
>I have checked the owner and it coincides with my logon name in my domain
>(i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
>problem with Active Directory? Why am I not being recognized as a valid db
>owner?

24 Jan 2006 11:06 PM

Erland Sommarskog

Juan Dent (Juan_Dent@nospam.nospam) writes:

> Every time I click on the Database Diagram node in object explorer in SQL
> Server Management Studio, I get a message:
>
> Database diagram support objects cannot be installed because this
> database does not have a valid owner. ...
>
> I have checked the owner and it coincides with my logon name in my domain
> (i.e. DENTDEVELOPMENT\JuanDent). What could be going on? Could I have a
> problem with Active Directory? Why am I not being recognized as a valid db
> owner?

This typically happens when you migrate a database from another server.
The problem can be seen by SELECT * FROM sys.database_principals. Compare
the row for dbo with a database created on the server.

I think changing the ownership to some other login, and back to yourself
fixes the issues.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

3 Feb 2006 1:06 PM

deniseanelson@comcast.net

This site will help. There are two quick steps.
http://mcfunley.com/cs/blogs/dan/archive/2005/12/23/899.aspx

:)

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...