Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2008
    Location
    NM, USA
    Posts
    97

    Unanswered: Problem Creating Diagrams

    Hi all,

    I'm working in SQL Servers 2008 Express, and I'm having a little issue here. It isn't letting me create database diagrams. I'm getting the following error:

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    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.

    ------------------------------
    BUTTONS:

    OK
    ------------------------------

    I'm pretty much a novice at this, and I've been trying to fix it, but I can't figure out what the problem is. Any pointers greatly appreciated.
    "Unix is user friendly... It's just very picky about its friends."

    The best things in life...are well-documented.

  2. #2
    Join Date
    Mar 2009
    Location
    Australia
    Posts
    113
    Just make sure the database has a valid owner...

    Code:
    ALTER AUTHORIZATION ON DATABASE::<YourDBName> TO <OwnerLoginName>

  3. #3
    Join Date
    Sep 2008
    Location
    NM, USA
    Posts
    97
    Quote Originally Posted by EngadaSQL View Post
    Just make sure the database has a valid owner...

    Code:
    ALTER AUTHORIZATION ON DATABASE::<YourDBName> TO <OwnerLoginName>

    Alright I guess I have to clarify that the most blatantly obvious solutions of using the alter authorization statement and attempting to change the owner in the database properties didn't work.
    "Unix is user friendly... It's just very picky about its friends."

    The best things in life...are well-documented.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Yes, you do need to clarify, always. Can you elaborate on "didn't work"?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •