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

Larry,

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

Cheers,
Dan

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

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) 2000¹

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

|||

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

|||

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