Windows Server 2003 supports SQL Server 2000
symptom
Microsoft Windows Server 2003 Product Series does not support SQL Server 2000 Service Pack 2 (SP2) and lower versions. When you install SQL Server 2000 on a computer running Windows Server 2003, you will receive the following warning message:
SQL Server 2000 SP2 and Below Is Not Supported by this Version of Windows.to Run The Program, Click Continue.For More Information, Click Details.
In addition, you may also encounter an unexpected phenomenon.
Note: Windows 2003 does not support Microsoft SQL Server 2000 Desktop Edition (MSDE) Service Pack 2 (SP2) and lower versions, but you will not receive warnings about these products during installation.
Note: Windows Server 2003 does not support SQL Server 2000 Analysis Services SP2 and lower versions, you will receive the warning message above.
the reason
This happens is that the Windows Server 2003 product line does not support SQL Server 2000 Service Pack 2 (SP2) and lower versions and components thereof.
alternative method
To resolve this issue, install SQL Server 2000 SP3 or higher after installing SQL Server 2000.
solution
SQL Server 2000 SP2 Configuration If you are currently running SQL Server 2000 SP2 or lower, and you want to upgrade your operating system to Windows Server 2003, upgrade to SQL Server SP3 or higher, then upgrade you Operating system.
Install new SQL Server 2000 If you want to install SQL Server 2000 and Windows Server 2003 at the same time, follow these steps:
Install Windows Server 2003. Install SQL Server 2000. Note: You will receive a warning message. When you receive a warning message, click OK. Upgrade to SQL Server SP3 or higher.
From: http://support.microsoft.com/default.aspx? ScID = KB; zH-CN; 329329
