Error while creating diagram.

Question

Post reply

Error while creating diagram.

NitinPatel31

Hall of Fame

Points: 3721
More actions
April 6, 2009 at 9:41 am

#202531

TITLE: Microsoft SQL Server Management Studio
------------------------------
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.
------------------------------
BUTTONS:
OK
------------------------------
I get the above error while creating the diagram. If I change the database owner to some SQL server user login then it works fine. But This error is comming only with database, which is having Domain Users login as owner.
Please help me about this. Is it compulsory to set sql login as database user owner Or I am missing something, while setting windows (domain user) user as database owner.
Regards,
Nitin

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jerry Hung SSChampion Points: 12968 More actions · Answer 1

Were those domain logins invalid?

I always set my newly created databases owner to 'sa'

To avoid issues like this, and also when someone leaves the company (AD account disabled), it won't cause an outage or errors

SQLServerNewbieMCITP: Database Administrator SQL Server 2005

NitinPatel31 Hall of Fame Points: 3721 More actions · Answer 2

Jerry Hung (4/6/2009)
Were those domain logins invalid?

This domain users are valid one. I am doing this on development server not on production. Assiging the SQL user has resolved the problem but I just want to know the reason, so that it can be helpful on production server.

Regards,
Nitin

Tom257 SSChampion Points: 11543 More actions · Answer 3

Just a thought, check the database compatibility level

I know a similar error to this happens in SQL2005 if you try to diagram a level 80 (SQL2000) database.

I don't have 2008 yet so this is just a stab in the dark.

NitinPatel31 Hall of Fame Points: 3721 More actions · Answer 4

Thanks..

But it is not even working after changing the compatibility mode.

Regards,
Nitin

write2himanshu Newbie Points: 3 More actions · Answer 5

Hi Folks,

I got the same error message and tried the following solution after googling a bit.

Solution is as::

EXEC sp_dbcmptlevel '<Your Database>', '90';

go

ALTER AUTHORIZATION ON DATABASE::Your Database TO "USER LOGIN"

go

use [b]Your Database[/b]

go

EXECUTE AS USER = N'dbo' REVERT

go

Happy coding!!

Himanshu Sharma

(MCTS)

Software Developer