Installing SQL Server 2000 on Windows Server 2003

Q: I want to install SQL Server 2000 on Windows Server 2003, but when I do, I receive the error message SQL Server 2000 SP2 and below isn't supported by this version of Windows. To run the program, click Continue. For more information, click Details. I don't have an installed version of SQL Server 2000 that already has Service Pack 3 (SP3) applied, and I can't install SP3 until I apply SQL Server. How can I install SQL Server 2000 on Windows Server 2003 when the OS doesn't support this release?

A: The error message you're seeing has confused many people. Windows Server 2003 doesn't support SQL Server 2000 Service Pack 2 (SP2) and earlier, but you can install those releases. Immediately apply SP3 (or SP3a) once you've finished the installation. The error message can create a problem if you're trying to perform an unattended installation of SQL Server 2000 because insuppressible GUI messages don't cooperate with unattended installations. However, the Microsoft article "INF: How to Suppress the Appshelp Message in an Unattended Installation" (http://support.microsoft.com/?kbid =815430) provides a walk-through of registry key changes you can make to disable the error message. Disabling the error message will let an unattended installation proceed without problems. Microsoft has talked about shipping versions of SQL Server 2000 that have SP3a slip-streamed into the core SQL Server installation. However, those versions weren't available when I wrote this answer.

From the Blogs

Many organizations today cannot use public cloud solutions because of security concerns, administrative challenges and functional limitations. However, they still need a centralized platform where end users can conduct self-service analytics in an IT-enabled environment....More

It is crucial to move away from data and analytics stored on individual desktop computers. Today’s solutions must promote holistic, collective intelligence. The strong, continued alliance between Microsoft and Pyramid Analytics helps make all this possible....More

To become a truly data-driven enterprise, many business leaders recognize that they must extend the capabilities of self-service business intelligence (BI) and analytics to more of their business users. Many BI tools tackle part of this need, but they don’t offer a complete enterprise solution....More