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

So many bugs, so litle time... =)...  the issue is that I was trying to add some diagrams while checking some details on Database Design, and when I right click the Diagram folder on Management Studio (SQL SERVER 2014), the error message hit me:

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

After some googling I found a couple answers on SQL SERVER Central and SQL Authority. This is a quite common error when you are working with a Database that has been restored from another server and the previous db owner (user) isn't created on the new server.

Basically, you need to change the authorization on your server. This is the syntax (copied from sql authority):

ALTER AUTHORIZATION ON DATABASE::YourDatabaseName TO sa

GO

Worked fine on my development database, but as Pinal Dave said, not recommended on production.

Check out my new book about R Language.