Is SQL Server Standard 2000 SP3 compatible with Windows Server 2003 Standard R2

I need to know if Microsoft SQL Server Standard 2000 SP3 will run on a 64-bit platform and also whether it will run on Windows Server 2003 Standard R2.
SuePhAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ktaczalaCommented:
yes, 32 bit SQL will run on a 64 Bit system
0
Asif BacchusI.T. ConsultantCommented:
I would quite strongly recommend you use SQL Standard 2000 SP4 (not SP3) if you are installing to a x64 installation of Server 2003 R2.  SP4 was the first SP to incorporate full support for running x86 databases on x64 systems.  Make sure you fully update your SP4 installation also since there was an issue with AWE support (if you need it, databases 2GB+) on SP4 before it's first round of updates.

If you *have* to use SP3 for some reason, then you will likely have to run the installer with at least the /force option to skip machine checks.  There is another option I'm forgetting off-hand to skip machine checks also, but you can get that using setup /?.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Server Software

From novice to tech pro — start learning today.