Solved

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

Posted on 2014-11-17
2
228 Views
Last Modified: 2014-11-18
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.
0
Comment
Question by:SuePh
2 Comments
 
LVL 12

Assisted Solution

by:ktaczala
ktaczala earned 250 total points
Comment Utility
yes, 32 bit SQL will run on a 64 Bit system
0
 
LVL 6

Accepted Solution

by:
Asif Bacchus earned 250 total points
Comment Utility
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

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Citrix XenApp, Internet Explorer 11 set to Enterprise Mode and using central hosted sites.xml file.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now