sqlServer 2000 and 2005 coexist?

7 Jul 2005 4:55 PM

Peter Rilling

Hi,

Is it possible for both SqlServer 2000 and SqlServer 2005 to coexist on the
same box? Would there be any need to have them both running (like for
backward compatibility)?

7 Jul 2005 5:04 PM

Aaron Bertrand [SQL Server MVP]

> Is it possible for both SqlServer 2000 and SqlServer 2005 to coexist on
> the
> same box?

Yes. But only one can be the default instance.

> Would there be any need to have them both running (like for
> backward compatibility)?

That is more a business requirements question, I think. You can always run
SQL Server 2005 in 2000 compatibility mode, so I doubt you would ever need a
true 2000 instance to fall back on. But better safe than sorry, I
suppose...

7 Jul 2005 7:38 PM

Ravi

FYI All the client programs will be upgraded to 2k5 tools. You can use EM or
QA. You have to use Management Studio to manager both 2k and 2k5

--
Thanks & Rate the Postings.
-Ravi-

Show quote

"Peter Rilling" wrote:

> Hi,
>
> Is it possible for both SqlServer 2000 and SqlServer 2005 to coexist on the
> same box? Would there be any need to have them both running (like for
> backward compatibility)?
>
>
>
>