Database diagram support object cannot be installed because this database does not have a valid owner

Pernah error seperti ini di SQL server management studio ?

database diagram support object cannot be installed because this database does not have a valid owner

Ganti user ke sa melalui management studio :

1. klik kanan database database, choose properties
2. Pilih Options Page
3. pada menu Dropdown sebelah kanan “Compatibility Level” pilih “SQL Server 2005(90)”
4. Pilih Files Page
5. masukan user “sa” di owner textbox.
6. Pilih OK