Hello,

I have never built a SQL Server before. Is it possible to install a
full version of SQL Server 2000 on top of Windows Server 2003 (one
server for an application and database server)? If so, are there any
tricks to it or would I simply install Server 2003 first then install
SQL Server 2000 on top of it? I must install SQL Server 2000 to
support a legacy app that currently uses it.

Any information would be greatly appreciated.

Thank you,
Diego

It's really no big deal. Just be sure to install the latest service packs
and hotfixes to each. Preferably, do the service packs and hot fixes to
the OS, then install SQL Server and apply its SP's and HF's.

Keep in mind that SQL Server likes memory, so if your app that also runs on
the same server likes memory, then there will be some resource contention.
Same would go for other resources.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


<newtothadu@yahoo.com> wrote in message
news:1185554664.420132.43110@57g2000hsv.googlegrou ps.com...
Hello,

I have never built a SQL Server before. Is it possible to install a
full version of SQL Server 2000 on top of Windows Server 2003 (one
server for an application and database server)? If so, are there any
tricks to it or would I simply install Server 2003 first then install
SQL Server 2000 on top of it? I must install SQL Server 2000 to
support a legacy app that currently uses it.

Any information would be greatly appreciated.

Thank you,
Diego

It works. I'm doing it here on a couple of machines for the same
reason. Install the OS, then SQL Server. Note SQL Server 2000 must be
updated to a given SP level before it will run on 2003 - it tells you
that when you do the install. Just ignore it, proceed, and update after
the install.


newtothadu@yahoo.com wrote:
> Hello,
>
> I have never built a SQL Server before. Is it possible to install a
> full version of SQL Server 2000 on top of Windows Server 2003 (one
> server for an application and database server)? If so, are there any
> tricks to it or would I simply install Server 2003 first then install
> SQL Server 2000 on top of it? I must install SQL Server 2000 to
> support a legacy app that currently uses it.
>
> Any information would be greatly appreciated.
>
> Thank you,
> Diego
>

Plus, if this is a web application running on IIS,make sure you configure
your application pool properly


"Brett I. Holcomb" <brettholcomb@bellsouth.net> wrote in message
news:O0JjusI0HHA.4712@TK2MSFTNGP04.phx.gbl...
> It works. I'm doing it here on a couple of machines for the same reason.
> Install the OS, then SQL Server. Note SQL Server 2000 must be updated to
> a given SP level before it will run on 2003 - it tells you that when you
> do the install. Just ignore it, proceed, and update after the install.
>
>
> newtothadu@yahoo.com wrote:
>> Hello,
>>
>> I have never built a SQL Server before. Is it possible to install a
>> full version of SQL Server 2000 on top of Windows Server 2003 (one
>> server for an application and database server)? If so, are there any
>> tricks to it or would I simply install Server 2003 first then install
>> SQL Server 2000 on top of it? I must install SQL Server 2000 to
>> support a legacy app that currently uses it.
>>
>> Any information would be greatly appreciated.
>>
>> Thank you,
>> Diego
>>