title: Database Diagram Support Objects cannot be Installed ... no valid owner
body: <p>I tried to create a database diagramm with SQL Server 2008, but an error occurs:</p>
  
  <blockquote>
    <p>Database diagram support objects
    cannot be installed because this
    database does not have a valid owner.
    To continue, first use the Files page
    of the Database Properties dialog box
    or the ALTER AUTHORIZATION statement
    to set the database owner to a valid
    login, then add the database diagram
    support objects.</p>
  </blockquote>
  
  <p>Then I tried the following:</p>
  
  <pre><code>EXEC sp_dbcmptlevel 'Ariha', '90';
  GO
  ALTER AUTHORIZATION ON DATABASE::Ariha TO [WIN-NDKPHUPPNFL\Administrator]
  GO
  USE Ariha
  GO
  EXECUTE AS USER = N'dbo' REVERT
  GO
  </code></pre>
  
  <p>Next erorr pops up: </p>
  
  <blockquote>
    <p>Msg 15404, Level 16, State 11, Line 1
    Could not obtain information about
    Windows NT group/user
    'WIN-NDKPHUPPNFL\Administrator', error
    code 0x534.</p>
  </blockquote>
  
  <p>The Problem is the name of the PC has changed into "DevPC" I also changed this in the update script, but still the same error 15404. </p>
  
  <p>What can I do to fix this annoying error?</p>