You get this message when trying to create a SQL Database diagram

Cannot execute as the database principal because the principal "dbo" 
does not exist, this type of principal cannot be impersonated,
or you do not have permission.

After restoring a database from another server you see this

Solution

use [YourDatabaseName] EXEC sp_changedbowner 'sa'