SQL server 2005 express install together with SQL server 2000 developer ed.

I have just installed the VB 2005 express. I have a prior installation of SQL server 2000 developer that I would prefer to keep on my computer. Does this mean I cannot install the included SQL server 2005 express

Answer this question

SQL server 2005 express install together with SQL server 2000 developer ed.

Daniel McElhinney

Hi,

I have a Microsoft SQL Server 2005 installed in a folder named \Microsoft SQL Server

and I tryed to install SQL Server 2005 Express but it resulted in the message:

* To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter.

I want both server to be installed and my question is how to accomplish that

Regard

EGO
kari0002
No you can use both on the same machine. The only difference is that the SQL Server Express edition will install as a named instance on the machine, this means that to connect to it you would have to connect to the server using the following name "<Machinename>\SQLExpress", or ".\SQLExpress".

I am currently running a development Small Business Server that has SQLServer 2000 Developer Edition, the Built in MSDE system for Share point Services, and an install of SQL Server Express Edition.
Timelapse
New to programming - wish to build a new website using vwd 2005 express and sql server 2005 express on my local computer - our web server has sql server 2000 installed - can our web server have sql server 2005 express edition installed on it as well as the existing 2000 version (robust) and utilize the sql server 2005 express database when the new website is published
Greg B.
What about using sql server express 2005 which installes with VS Pro 2005, and also the sql developer edition 2005 which is included with the package when purchased Any conflicts, why install the dev edition Any helpful insight will be helpful.
hwiz

Yes you can use it, when you install SQL Express it will install under the instance name of SQLEXPRESS, this means that when you connect you need to use the following format <ServerName>\SQLEXPRESS.

for more information on connections strings drop over to www.connectionstrings.com
Bruno Caponi
Thanks. It was mot helpful.
dseifert
Hello,

I have a w2k3 server with sql server 2005 installed on it.

Now I want to install FSC Serverview management tool but this tool wants to install MSDE 2000. Can I install MSDE 2000 next to sql server 2005 without any problems

Thanks for your help.

Kris
Leon Bouquiet

There are no problems doing this as they install to different instances on your machine. And as to the question about why install dev... there are many differences in the two versions, and depending on the applications tat you are working on you might use either. I have some clients that prefer to use the full package DB Engine, but others who like to cut costs and the express version is perfect.
SQL server 2005 express install together with SQL server 2000 developer ed.

Answer this question