Home > Archive > MS SQL Server > October 2006 > Can we install SQL Server 2000 on same server with SQL Server 2005









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Can we install SQL Server 2000 on same server with SQL Server 2005
Marceepoo

2006-10-24, 6:37 pm

We have SQL Server 2005 running on our main server. We need to install an
application that is programmed for SQL Server 2000. We are planning to have
the application upgraded to SQL Server 2005, but that will take time and we
want to get the current version of the application running asap.

Ques: Can we install SQL Server 2000 on the same server, or would that
create any suffering (incompatibilities, crashes, etc.)?

Any input, or suggestions where I could find the answer(s) I'm seeking,
would be much appreciated. Thanks in advance.

Marceepoo
amish

2006-10-24, 6:37 pm


Marceepoo wrote:

> We have SQL Server 2005 running on our main server. We need to install an
> application that is programmed for SQL Server 2000. We are planning to have
> the application upgraded to SQL Server 2005, but that will take time and we
> want to get the current version of the application running asap.
>
> Ques: Can we install SQL Server 2000 on the same server, or would that
> create any suffering (incompatibilities, crashes, etc.)?
>
> Any input, or suggestions where I could find the answer(s) I'm seeking,
> would be much appreciated. Thanks in advance.
>
> Marceepoo



On some servers we have installed SQL Server 2005 and then SQL Server
2000 later on .
Its working fine without probs.

Regards
Amish Shah
http://shahamishm.tripod.com

Hilary Cotter

2006-10-24, 6:37 pm

Works great for me. Manage both the SQL 2000 and SQL 2005 servers using SSMS
as opposed to Enterprise Manager.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"Marceepoo" <36c53a08-2073470544@news.postalias> wrote in message
news:883649E2-8843-441F-97BB- 54DD11986B80@microso
ft.com...
> We have SQL Server 2005 running on our main server. We need to install an
> application that is programmed for SQL Server 2000. We are planning to
> have
> the application upgraded to SQL Server 2005, but that will take time and
> we
> want to get the current version of the application running asap.
>
> Ques: Can we install SQL Server 2000 on the same server, or would that
> create any suffering (incompatibilities, crashes, etc.)?
>
> Any input, or suggestions where I could find the answer(s) I'm seeking,
> would be much appreciated. Thanks in advance.
>
> Marceepoo



Amt Basu

2006-10-24, 6:37 pm

Yes - you can have multiple instances of both the servers in the same
machine. Just make sure that you don't have unnamed default instance for both
of them - any one of them works fine without conflicts.
Thanks

"Marceepoo" wrote:

> We have SQL Server 2005 running on our main server. We need to install an
> application that is programmed for SQL Server 2000. We are planning to have
> the application upgraded to SQL Server 2005, but that will take time and we
> want to get the current version of the application running asap.
>
> Ques: Can we install SQL Server 2000 on the same server, or would that
> create any suffering (incompatibilities, crashes, etc.)?
>
> Any input, or suggestions where I could find the answer(s) I'm seeking,
> would be much appreciated. Thanks in advance.
>
> Marceepoo

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2009 droptable.com