Sometimes when we try to create or view a database diagram we are not able to access it. we get following error
This is an ownership problem.
You just need to add owner of the database and you are good to go.
You can add db owner as shown in below
Above step will resolve the problem.
Enjoy and share with others.