Usually, we will face an issue with Database diagrams. Below is the error while trying to create new database diagrams.
This issue is due to access. While upgrading your database or attaching or restoring a lower version of database into higher version of server. You will face this problem.
"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."
One of the best solution is mapping the database owner to a specific system owner or SQL authentication. For me, this text box is blank and I selected a particular user listed on clicking the small button near to the text box.
![]()
Cheers,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/