cannot install sql server 2005 developer over sql server 2000 desktop edition

It will not install the database components it refuses to install over the older desktop edition... what are we supposed to do.. we have many registered servers to all the customers and servers we use so we don't want to remove the older one... but we are developers and develop applications that our customers use and need the new version on these machines....

thanks




Answer this question

cannot install sql server 2005 developer over sql server 2000 desktop edition

  • TylerSchlegel

    Larry,

    Can you provide more details on what you mean by "it will not install..."

    Cheers,
    Dan



  • stewart05

    I assumed you knew it will install everything but the database component complaining about something to the regards of not be able to install developer over version 8.0.0.x.x or something due to licensing..

  • spg

    what a pain I had to remove everything.. express edition and sql server 2000 and then install...

    there should be an upgrade path from desktop edition to developr...

    anyway in the future when I do this I can backup databases... as I did but the big thing we loose is we have about 50 remote database connections in enterprise manager..

    is there a way to save these and then reimport them once 2005 is intalled...

    thanks..



  • Mike Gomez

    I
    f this is not enought I will run it again and give you the exact wording.. but it just disables installation of the database component and lets you go ahead with the rest. what is the point of installing the other stuff without the database component

  • galsheefone

    I don't think this covers it.. desktop edition is not the same as desktop engine... desktop edition is a special version on enterprise edition or standard cd's that can install on windows 2000 profesional instead of server...

    I did what you say and express installed.. but it does not have the management studio which we need to connect to our various development servers.. for our workstations..

    any ideas.. thanks



  • Chardon

    So you're trying to upgrade MSDE to what SQL Server 2005 Edition

    The supported upgrade paths for MSDE are:

    SQL Server Desktop Engine (MSDE) 7.0 SP4

    SQL Server 2005 Express Edition

    SQL Server Desktop Engine (MSDE) 20001

    SQL Server 2005 Workgroup Edition

    SQL Server 2005 Express Edition

    For the full matrix of supported upgrade paths look at: http://msdn2.microsoft.com/en-us/library/ms143393(en-US,SQL.90).aspx

    Cheers,
    Dan



  • cannot install sql server 2005 developer over sql server 2000 desktop edition