Can 6.5, 7.0 and 2000 all co-exist on same machine ?

[Rob]

I'm currently running SQL Server 6.5 and 7.0 together on the same
machine (i.e. switchable using the program switcher). Does anyone
know if i can install SQL Server 2000 to run alongside both of these?

Thanks in anticipation.
Rob

[Steve Troxell]

Rob wrote:

I'm currently running SQL Server 6.5 and 7.0 together on the same
machine (i.e. switchable using the program switcher). Does anyone
know if i can install SQL Server 2000 to run alongside both of these?

7.0 and 2000 certainly can, if you install 2000 as a named instance. As to
whether 6.5 and 7.0 can co-exist, 6.5 is so ancient I can't recall. I do
believe there was some utility to switch between the two on the same
machine, but not so much both available simultaneously.

--
Steve Troxell

[Rob]

Steve,
Thanks, i've inherited an old 6.5 database i'd like to keep a copy of
and also run 7 & 2000. Anyway think i've found the answer on the web:

<quote>
If both SQL Server 7.0 and 6.5 are installed on the computer and
coexist by means of a version switch and you don't want to upgrade an
existing installation, you can safely install named instances of SQL
Server 2000 on the same machine and host all three versions on the
same computer. However, only one of the versions (i.e., 7.0 or 6.5)
that coexist by means of a version switch can run at one time, whereas
all named instances can run simultaneously.
</quote>

Rob

On Fri, 05 Nov 2004 17:43:56 GMT, "Steve Troxell"
<st***********@nospam.hotmail.com> wrote:

Rob wrote:

I'm currently running SQL Server 6.5 and 7.0 together on the same
machine (i.e. switchable using the program switcher). Does anyone
know if i can install SQL Server 2000 to run alongside both of these?

7.0 and 2000 certainly can, if you install 2000 as a named instance. As to
whether 6.5 and 7.0 can co-exist, 6.5 is so ancient I can't recall. I do
believe there was some utility to switch between the two on the same
machine, but not so much both available simultaneously.