Solved

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

Posted on 2014-11-17
2
248 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
ID: 40449091
yes, 32 bit SQL will run on a 64 Bit system
0
 
LVL 6

Accepted Solution

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

The canonical version of this article is on my web site here: http://iconoun.com/articles/collisions/ A companion presentation is available here: http://iconoun.com/articles/collisions/Unicode_Presentation.pdf
Article by: Leon
Software Metering within our group of companies has always been an afterthought until auditing of software and licensing became a pain point. Orchestrator and SCCM metering gave us the answer and it was an exciting process.
Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

680 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