May 30, 2014

I am trying to add a database diagram for the tables in Sql Server Management Studio and it's failing with the message "Database diagram support objects cannot be installed because this database does not have a valid owner". This is a bit weird as I thought the owner is already set.

To fix the issue, open the properties dialog for the database by right clicking on the database. Navigate to the files option and then set the owner name appropriately to a valid login.



Reference: Shahed Kazi at