unable to add diagrams

• tshad

  SSCertifiable

  Points: 5905

  More actions

  August 19, 2013 at 1:40 pm

  #277167

  When I try to add it I get error saying that the database needs valid owner.

  On the "General" screen there is an Active Directory owner.

  but on the Files screen the owner is blank.

  Why is that and why do I need to have an owner there?

  Thanks,

  Tom

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  August 20, 2013 at 9:34 am

  #1643133

  I'm don't know the WHY, but I can tell you it is blank because the AD login that "owns" the database is not valid on that server either because the person no longer works for the company or the database has been restored on a server that does not have that login on it.

  If you are a sysadmin you can run ALTER AUTHORIZATION ON DATABASE::DatabaseName TO sa;

  I typically have the databases owned by sa since that will exist (even in Windows Authentication only servers) on all servers.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question