|
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 ??
(comments are locked)
|
|
It might be worth just running the command to see if it fixes any broken 'links' 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. 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
Aug 14 '12 at 08:48 AM
MuhSQL
(comments are locked)
|
|
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-HPHP DV6] 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
Aug 15 '12 at 09:57 AM
Kev Riley ♦♦
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.
Aug 15 '12 at 10:25 AM
Usman Butt
(comments are locked)
|
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.
I login as SysAdmin