Can I install 32-bit SQL2000 on 64-bit W2K3 R2 OS?

Maybe this is a stupid question, but we're ordering a new server, and we get our choice of OS with it. So I'd like to have 64-bit OS if I can.

In the larger plan, is there any problem upgrading from 32-bit SQL2000 to 64-bit SQL2005?

Thanks!!

You can, but SQL 2000 32-bit must be fully patched in order to be stable on 64-bit hardware.

I haven't heard of any issues during migration from 32-bit 2000 to 64-bit 2005. I advise doing that as soon as possible to reap the benefits

-Ryan / Kardax

|||Thank you so much! That was exactly what I needed to know!

Can 32 bit webserver work with a 64 bit db server?

Is it possble for a W2K3 32-bit webserver running IIS6 access a SQL 2005
server running W2K3 64 bit?
tia
--
MGYes. The SQL Client libraries do not care about the architecture of the
server they connect to. From the client point of view, all SQL Servers are
the same.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Hurme" <michael.geles@.thomson.com> wrote in message
news:82AB06A7-DD7A-46D9-8F0C-F4934C8688C1@.microsoft.com...
> Is it possble for a W2K3 32-bit webserver running IIS6 access a SQL 2005
> server running W2K3 64 bit?
> tia
> --
> MG

Can 32 bit webserver work with a 64 bit db server?

Is it possble for a W2K3 32-bit webserver running IIS6 access a SQL 2005
server running W2K3 64 bit?
tia
MG
Yes. The SQL Client libraries do not care about the architecture of the
server they connect to. From the client point of view, all SQL Servers are
the same.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Hurme" <michael.geles@.thomson.com> wrote in message
news:82AB06A7-DD7A-46D9-8F0C-F4934C8688C1@.microsoft.com...
> Is it possble for a W2K3 32-bit webserver running IIS6 access a SQL 2005
> server running W2K3 64 bit?
> tia
> --
> MG