Database diagram Error

  • Hi all,

    One of my server sql 2005, I still get the error when clicking the Database Diagrams folder:

    "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."

    Howerver, I changed compatibility level :  EXEC sp_dbcmptlevel 'database_name', '90';

    And authorization on my database  : ALTER AUTHORIZATION ON DATABASE::database_name TO valid_login.

    I installed SQL 2005 SP1 on my server.

    I don't understand, cause on my other server is work. 

    Have you got an idea ?

     

     


    Kindest Regards,

    degrem_m
    Degremont

  • Sorry, I found it. I forgot to choose in database properties my user owner.

    In SQL Server Management Studio do the following:

    1. Right Click on your database, choose properties

    2. Goto the Files Page

    3. Enter "my user" in the owner textbox.


    Kindest Regards,

    degrem_m
    Degremont

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply