question

MuhSQL avatar image
MuhSQL asked

Problem with Database diagram

Dear all, I install SQL Server 2008 R2 on Win7 ,and after I created database and tables,When I click the New Database Diagram this message appeared : **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.** I checked the owner and its valid ...any idea ??
sql-server-2008-r2configuration
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

swirl80 avatar image swirl80 commented ·
Is the user you're trying to set as the owner a sysadmin? If not you may have to recreate the login mapping to the database in question.
0 Likes 0 ·
MuhSQL avatar image MuhSQL commented ·
I login as SysAdmin
0 Likes 0 ·

2 Answers

·
Kev Riley avatar image
Kev Riley answered
It might be worth just running the command to see if it fixes any broken 'links' alter authorization on database::YourDatabaseName to YourValidUser Also, are you creating the database from new, or have you restored/attached a previous one? If so you may need to check the compatibility level.
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

MuhSQL avatar image MuhSQL commented ·
Thanks Kev, I created the database from new ,but If I attach the database (DB created with sql server 2005) the Diagram will work but with new database doesn't work
0 Likes 0 ·
MuhSQL avatar image
MuhSQL answered
I solved the problem by change the login from win auth to SQL server auth [sa] and use the command : alter authorization on database::TEST to [sa] But with Win auth doesn't work If I use win login and the command is :- alter authorization on database::TEST to [HPDV6-HP\HP DV6]
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Kev Riley avatar image Kev Riley ♦♦ commented ·
It is better to use SQL logins for this kind of ownership anyway : http://sqlblog.com/blogs/tibor_karaszi/archive/2009/12/30/using-sa-as-owner-for-jobs-and-databases.aspx
0 Likes 0 ·
Usman Butt avatar image Usman Butt commented ·
if IIRC, for the very first use of Database Diagram Designer, it must be set up by a member of the db_owner role, otherwise it would not work.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.