Microsoft KB Archive/329329

From BetaArchive Wiki

Article ID: 329329

Article Last Modified on 12/13/2005



APPLIES TO

  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 2000 Desktop Engine (Windows)



This article was previously published under Q329329

SYMPTOMS

SQL Server 2000 Service Pack 2 (SP2) and earlier are not supported by the Microsoft Windows Server 2003 family. When you install SQL Server 2000 on a computer running Windows Server 2003, you receive the following warning message:


SQL Server 2000 SP2 and below
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.

Additionally, you may experience unexpected behavior.

Note Microsoft SQL Server 2000 Desktop Edition (MSDE) Service Pack 2 (SP2) and earlier are also not supported on Windows 2003, but you do not receive a warning about them during the installation.

Note SQL Server 2000 Analysis Services SP2 and earlier are not supported on Windows Server 2003, and you will receive this warning message.

CAUSE

This behavior occurs because SQL Server 2000 Service Pack 2 (SP2) and earlier and its components are not supported by the Windows Server 2003 family.

WORKAROUND

To work around this behavior, install SQL Server 2000 SP3 or later immediately after you install SQL Server 2000. For more detailed installation information, see the “More Information” section in this article.

RESOLUTION

SQL Server 2000 SP2 configuration

If you are currently running SQL Server 2000 SP2 or earlier and you want to upgrade your operating system to Windows Server 2003 upgrade to SQL Server SP3 or higher, and then upgrade your operating system. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 How to obtain the latest SQL Server 2000 service pack


SQL Server 2000 new installation

If you are installing SQL Server 2000 and Windows Server 2003 at the same time, follow these steps:

  1. Install Windows Server 2003.
  2. Install SQL Server 2000.


Note: You will receive the warning message. When you do, click OK.

  1. Upgrade to SQL Server SP3 or later.


MORE INFORMATION

For more information about SQL Server 2000 and Windows Server 2003, click the following article number to view the article in the Microsoft Knowledge Base:

811054 PRB: Virtual SQL Server 2000 installation fails on cluster that has eight nodes


For more information about support for Microsoft SQL Server 7.0 or earlier and Windows Server 2003, click the following article number to view the article in the Microsoft Knowledge Base:

810391 INF: SQL Server 6.5, 7.0 and MSDE 1.0 support on Windows Server 2003



Additional query words: Windows 2003, Windows .Net , install, warning, SQL Server 2000 SP2 and below is not supported by this version of Windows, error

Keywords: kbprb kberrmsg KB329329