Wednesday, March 28, 2012

MSSQL 2000 + MSSQL 2005 on the same machine ?

Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
? Or is NOT recommended to do so ? Thanks !
JulichHi,
If it is production; I will not recommend both in the same machine.
Personally, I mainly run SQL 2005 on a virtual machine.
Thanks
Hari
SQL Server MVP
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>|||SQL 2005 must be installed after SQL 2K I think... On my deve machine
however I also was running Reporting Services. When I installed SQL 2005
reporting services it broke my sql 2k RS..
I'm with Hari -not on a production machine definitely - and risky on a dev
machine...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>|||They work together, but since the code is still BETA for SQL 2005 do not put
on production.
One thing I lost with it in my dev environment was Query Analyzer no longer
gives color coding, so I have to use SQL Server Management Studio for
everything if I want color coding.
"Julien Cheyssial" <julich@.gmail.com> wrote in message
news:1126457667.229869.247170@.z14g2000cwz.googlegroups.com...
> Is it possible to install MSSQL 2000 and MSSQL 2005 on the same machine
> ? Or is NOT recommended to do so ? Thanks !
> Julich
>

No comments:

Post a Comment