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

Question

I have two databases, production and stage. I am getting the error message in the title of this post when I click "Database Diagrams" for production, but on stage I don't get an error.

I've researched this message, and I've found posts such as this: http://geekswithblogs.net/shahed/archive/2007/11/19/116940.aspx

They pretty much say to change the owner of my database to sa. I'm not convinced this is the issue, though, because both production and stage databases have the same owner (not sa), but I only get this error for production.

Does anyone else know how else to resolve this error message?

Answer 1

both production and stage databases have the same owner (not sa), but I only get this error for production.

That usually is the very source of the problem: a database created on one machine is restored on a different machine where the SID of the original creator is no longer valid. Change the owner to a valid one:

ALTER AUTHORIZATION ON DATABASE::[<dbname>] TO sa;