Database diagram support objects cannot be installed   

Hi!

i've created a database with several tables and two schemas. Now I wanted to 
create a diagram but get the following error.

    Database diagram support objects cannot be installed because this 
database does not have a valid owner.      To continue, first use the Files 
page of the Database Properties dialog box or the ALTER AUTHORIZATION 
statement to set the database owner to a valid login, then add the database 
diagram support objects.

Why is that? How to fix it?

Thank you!

-- 
Zaur Bahramov, MCP

date: Thu, 28 Aug 2008 17:01:53 +0200   author:   Zaur Bahramov

Re: Database diagram support objects cannot be installed   

I tried to run:

    EXEC sp_dbcmptlevel 'Ricambi', '90';
    go
    ALTER AUTHORIZATION ON DATABASE::Ricambi TO "WIN2K3STD01\Administrator"
    go
    use [Ricambi]
    go
    EXECUTE AS USER = N'dbo' REVERT
    go

But get this error:

    DBCC execution completed. If DBCC printed error messages, contact your 
system administrator.
    Msg 15110, Level 16, State 1, Line 1
    The proposed new database owner is already a user or aliased in the 
database.
    Msg 15517, Level 16, State 1, Line 1
    Cannot execute as the database principal because the principal "dbo" 
does not exist, this type of principal         cannot be impersonated, or 
you do not have permission.




-- 
Zaur Bahramov, MCP
"Zaur Bahramov"  ha scritto nel messaggio 
news:%23XOTD8RCJHA.5196@TK2MSFTNGP04.phx.gbl...
> Hi!
>
> i've created a database with several tables and two schemas. Now I wanted 
> to create a diagram but get the following error.
>
>    Database diagram support objects cannot be installed because this 
> database does not have a valid owner.      To continue, first use the 
> Files page of the Database Properties dialog box or the ALTER 
> AUTHORIZATION statement to set the database owner to a valid login, then 
> add the database diagram support objects.
>
> Why is that? How to fix it?
>
> Thank you!
>
> -- 
> Zaur Bahramov, MCP
>

date: Thu, 28 Aug 2008 17:05:54 +0200   author:   Zaur Bahramov

Re: Database diagram support objects cannot be installed   

OK. I've fixed this one.
I had to read the error message better.

DROP USER "WIN2K3STD01\Administrator"

and re-runing

    EXEC sp_dbcmptlevel 'Ricambi', '90';
    go
    ALTER AUTHORIZATION ON DATABASE::Ricambi TO "WIN2K3STD01\Administrator"
    go
    use [Ricambi]
    go
    EXECUTE AS USER = N'dbo' REVERT
    go

resolved the problem.


-- 
Zaur Bahramov, MCP
"Zaur Bahramov"  ha scritto nel messaggio 
news:uUI1S%23RCJHA.2292@TK2MSFTNGP02.phx.gbl...
>I tried to run:
>
>    EXEC sp_dbcmptlevel 'Ricambi', '90';
>    go
>    ALTER AUTHORIZATION ON DATABASE::Ricambi TO "WIN2K3STD01\Administrator"
>    go
>    use [Ricambi]
>    go
>    EXECUTE AS USER = N'dbo' REVERT
>    go
>
> But get this error:
>
>    DBCC execution completed. If DBCC printed error messages, contact your 
> system administrator.
>    Msg 15110, Level 16, State 1, Line 1
>    The proposed new database owner is already a user or aliased in the 
> database.
>    Msg 15517, Level 16, State 1, Line 1
>    Cannot execute as the database principal because the principal "dbo" 
> does not exist, this type of principal         cannot be impersonated, or 
> you do not have permission.
>
>
>
>
> -- 
> Zaur Bahramov, MCP
> "Zaur Bahramov"  ha scritto nel messaggio 
> news:%23XOTD8RCJHA.5196@TK2MSFTNGP04.phx.gbl...
>> Hi!
>>
>> i've created a database with several tables and two schemas. Now I wanted 
>> to create a diagram but get the following error.
>>
>>    Database diagram support objects cannot be installed because this 
>> database does not have a valid owner.      To continue, first use the 
>> Files page of the Database Properties dialog box or the ALTER 
>> AUTHORIZATION statement to set the database owner to a valid login, then 
>> add the database diagram support objects.
>>
>> Why is that? How to fix it?
>>
>> Thank you!
>>
>> -- 
>> Zaur Bahramov, MCP
>>
>
>

date: Thu, 28 Aug 2008 17:13:37 +0200   author:   Zaur Bahramov