SQL SERVER database DIAGRAMS problem...

Hot Topic

Updating Table Structures
Changing ports sql 2005 listens on.
MSDE to SQL Server 2005 Express upgrade, possible bug?
Display Boolean parameter LABELS
Failed Install of SQL Server 2005 SP1 CTP
Extracting month, day, year from dates
SQL Server Management Studio Express CTP - not working
Thank you so much, Chad.
Failed to access IIS metabase???
Problem to create assembly which depends on other dll's from SQL Server

SQL Server

Installing Reporting Services Separate from Analysis Services
How do I get the script to create a table & all the Indexes
Sql Server Express Database login problem
Implementing message queue in SQL Server 2000
Orphaned Request will not be terminated
is vb.net 2003 compatible with sql server express?
SSIS package execution question in SQL agent
ForEach Loop utilisation
Shading By Value
Invoice Pagination - How do I start next costomer on new sheet when needed?

SQL SERVER database DIAGRAMS problem...

Hi all,
 i m trying to create database diagram but as soon as i click on DATABASE diagrams it gives me 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
------------------------------

what should i do since i m new to sql server....so,i cant understand what exactly i have to do can someone explain me in simple words....
thnks in advance.

Answer this question

SQL SERVER database DIAGRAMS problem...

  • tatero

    Hi Max, am George, i have been trying to use database diagrams with sql server 2005 standar edition i have visual studio .net 2005 standar edition too, i have read your post but i dont have the option in the Dropdown from the Compatibily level from the option page the label with the option "SQL Server 2005(90)", it only appears "SQl Server 2000" and "SQL Server 7.0"....please help, what can i do!....


    thx for your time. 

  • Marco Dorantes

    Excellent!  Beer's on Me!  Big Smile

  • pasand

    Schilmon ----- you are the best, was driving me crazy ok yeah so your message was posted ages ago but still your the best

  • arl_garm

    WOWWWWWWWWWWWWW.....It really worked...i cant believe this.....compatibility level was already the same....but just by writtin sa...it solved my problem...
    Thanks a ton....
    Regards,
    Shuch..

  • tmasboa

     Schilm wrote:
    I just spent 3 hours farting around with Permissions and all sorts of other options in SQL Server 2005. (oodles of fun... looks like all these damn settings and whatnot are gonna be just as convoluted as they were in 2000... oh well... makes life interesting ;-))

    I finally, I think, figured out what the problem is.

    In SQL Server Management Studio do the following:

    1. Right Click on your database, choose properties
    2. Goto the Options Page
    3. In the Dropdown at right labeled "Compatibility Level" choose "SQL Server 2005(90)"
    4. Goto the Files Page
    5. Enter "sa" in the owner textbox.
    6. Hit OK

    after doing this, I am now able to access the Database Diagrams.

    It would be nice to know the reasons behind the error (or maybe even a more descriptive error message.....)

    but this seems to have done the trick for me. Your mileage may vary

    -Max Schilling


  • Brian Pursley

    I just spent 3 hours farting around with Permissions and all sorts of other options in SQL Server 2005. (oodles of fun... looks like all these damn settings and whatnot are gonna be just as convoluted as they were in 2000... oh well... makes life interesting ;-))

    I finally, I think, figured out what the problem is.

    In SQL Server Management Studio do the following:

    1. Right Click on your database, choose properties
    2. Goto the Options Page
    3. In the Dropdown at right labeled "Compatibility Level" choose "SQL Server 2005(90)"
    4. Goto the Files Page
    5. Enter "sa" in the owner textbox.
    6. Hit OK

    after doing this, I am now able to access the Database Diagrams.

    It would be nice to know the reasons behind the error (or maybe even a more descriptive error message.....)

    but this seems to have done the trick for me. Your mileage may vary

    -Max Schilling

  • Pikechan

    This was the same for me until I installed the 2005 Server components.  My first run through installing SQL Sever 2005 I only installed the client tools and the Integration Services.

    Make sure you have the Server components installed which will upgrade your SQL Server 2000 services to 2005.
  • SQL SERVER database DIAGRAMS problem...
Answer this question