Tips and Tricks for:  SQL Server, Windows 2003

The Problem:   Windows 2003 says that you can't install SQL Server 2000 with Service Pack 2 or below.

When you start installing SQL Server 2000 you get a rather ugly message as shown below "SQL Server 2000 SP2 and below is not supported by this version of Windows".   Since you can't install a service pack without first installing SQL Server it looks like there's no way to complete the installation.

Solution: Go ahead and do it anyway. Click Continue.

This is a warning that you'll just have to live with There's just no other way.   Go ahead and continue with the install and then when  you're done, install service pack 3a.