Multiple installations of SqlServer on same server.

Hi all,
Can anyone advise on installing multiple versions of
SqlServer 2000 (ver 8) on the same server whilst
maintaining the integrity of previous installations of
SqlServer ?
Thanks in advance.
jTHere are no integrity issues involving multiple instances on the same box,
one instance is independent of the other, with one exception... - they both
will compete for memory. So unless you will be running only one at a time, I
would advise you to set max memory for each instance, assigning the
appropriate memory, so the instances do not compete in this regard...
"jimA" <jima@.pt.lu> wrote in message
news:075a01c35cc1$b7c0df60$a601280a@.phx.gbl...
> Hi all,
> Can anyone advise on installing multiple versions of
> SqlServer 2000 (ver 8) on the same server whilst
> maintaining the integrity of previous installations of
> SqlServer ?
> Thanks in advance.
> j|||You can install multiple instance of SQL 2000 on the same server. Each
is independent and can be at different service pack levels. Only the
tools are shared.
It's generally best to deploy a single instance unless you have a
specific reason to do otherwise, such as special security isolation
requirements or independent test environments. See the Books Online
<architec.chm::/8_ar_cs_5upf.htm> for recommendations. Also note that
licensing restrictions vary by edition.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"jimA" <jima@.pt.lu> wrote in message
news:075a01c35cc1$b7c0df60$a601280a@.phx.gbl...
> Hi all,
> Can anyone advise on installing multiple versions of
> SqlServer 2000 (ver 8) on the same server whilst
> maintaining the integrity of previous installations of
> SqlServer ?
> Thanks in advance.
> j|||Guys,
Many thanks, your comments were much appreciated.
j
>--Original Message--
>Hi all,
>Can anyone advise on installing multiple versions of
>SqlServer 2000 (ver 8) on the same server whilst
>maintaining the integrity of previous installations of
>SqlServer ?
>Thanks in advance.
>j
>.
>