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 ??
asked Aug 14 '12 at 05:29 AM in Default
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.
answered Aug 14 '12 at 07:33 AM
Kev Riley ♦♦
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]
answered Aug 15 '12 at 09:16 AM