Database diagram support objects cannot be installed
Simply try this.
Alter AUTHORIZATION ON DATABASE::YourDbName TO [sa];
This worked for me
ALTER AUTHORIZATION ON DATABASE ::DATABASE TO sa
Have you tried this set of steps, it might solve your problem:
In SQL Server Management Studio do the following:
- Right Click on your database, choose properties
- Go to the Options Page
- In the Dropdown at right labeled "Compatibility Level" choose "SQL Server 2005(90)"
- Go to the Files Page
- Enter "sa" in the owner textbox.
- Hit OK
Assuming this works and you can add DB diagrams, you can then change the owner back to your Windows user name.