Select the product you need help with

INF: Can Only Apply SQL Server 2000 Desktop Engine Service Pack 2 Download on the Internet to Instances Installed from Sqlrun01.msi

Article ID: 315721

This article was previously published under Q315721

Summary

If you download the Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Service Pack 2 (SP2) file from the Internet, you can apply the service pack only to instances of the Desktop Engine installed by using Sqlrun01.msi. If you attempt to apply the service pack to instances created by using Sqlrun02.msi through Sqlrun16.msi from the Setup.exe file that you downloaded from the Internet, one of the following error messages occur:

This installation package could not be opened. Verify that the package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer package.

-or-

The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.

Note This information also applies to Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Service Pack 3 (SP3).

More information

Service packs are the means by which Microsoft distributes bug fixes. Service packs keep a product current. Service packs include updates and may include system administration tools, drivers, and additional components, which are conveniently bundled for easy downloading. Service packs are cumulative; each new service pack contains all the fixes that are in previous service packs, as well as any new fixes. You do not need to install a previous service pack before you install the latest one. For example, you do not need to install Microsoft SQL Server 2000 Desktop Engine Service Pack 1 (SP1) before you install Microsoft SQL Server 2000 Desktop Engine Service Pack 2 (SP2).

The service pack for the SQL Server 2000 Desktop Engine (MSDE 2000) is intended for developers (ISVs) who create redistributable applications that use the Desktop Engine. If you are running an application that uses the Desktop Engine, contact your software provider for information about upgrading instances of the Desktop Engine installed by these applications. For more information, see the "Distributing the SQL Server 2000 Desktop Engine" topic in SQL Server 2000 Books Online.

SQL Server 2000 Desktop Engine Service Pack

The service pack for the Desktop Engine is provided in three forms:

SQL Server 2000 Service Pack 2 CD-ROM

This CD-ROM includes all of the files required to upgrade existing instances of the Desktop Engine. The maximum number of instances supported for the Desktop Engine is 16. This CD-ROM does not include the merge modules or .msi files required to install a new instance of the Desktop Engine.
To upgrade instances of the Desktop Engine created by using Sqlrun02.msi through Sqlrun16.msi, you must apply the service pack from the SQL Server 2000 Service Pack 2 CD-ROM. You can order this CD-ROM from Microsoft by visiting the Microsoft SQL Server Downloads Web site at:

SQL Server 2000 Service Pack 2
(http://www.microsoft.com/sql/downloads/2000/sp2.asp)
To upgrade instances of the Desktop Engine created by using Sqlrun02.msi through Sqlrun16.msi, you must apply the service pack from the SQL Server 2000 Service Pack 2 CD-ROM. You can order this CD-ROM from Microsoft by visiting the Microsoft SQL Server Downloads Web site at:SQL2KdeskSP2.exe

The MSDE 2000 downloadable file name is SQL2KDeskSP2.exe. This update includes:
- The Data engine.
- Database client connectivity components, such as:
  - The OLE DB Provider for SQL Server.
  - The SQL Server ODBC driver.
  - The client Net-Libraries.
You can download this self-extracting file from the Microsoft SQL Server Downloads Web site. This file includes an upgrade from an existing Instance-#01 MSDE 2000 installation that was created with sqlrun01.msi. You cannot use this download to upgrade instances of the Desktop Engine created by the use of any of the other *.msi files (Sqlrun02.msi through Sqlrun16.msi). The file does not include the merge modules or *.msi files that are required to install a new instance of the Desktop Engine. For more information, see Section 2.2 of the SQL Server 2000 Desktop Engine Service Pack 2 Readme.txt file.

Note To determine the instance number of your MSDE 2000 installation, refer to the following Microsoft Knowledge Base article:
311762
(http://support.microsoft.com/kb/311762/EN-US/ )
How to Identify Which MSI File Was Used for an Existing MSDE 2000 Installation.
If you have Instance #02 through 16, you must order the SQL Server 2000 SP2 CD.
To upgrade instances of the Desktop Engine created by using Sqlrun02.msi through Sqlrun16.msi, you must apply the service pack from the SQL Server 2000 Service Pack 2 CD-ROM. You can order this CD-ROM from Microsoft by visiting the Microsoft SQL Server Downloads Web site at:SQL Server 2000 Desktop Engine Service Pack 2 CD-ROM

If you are an application developer and need a FULL REFRESH of the MSDE 2000 files (which means that it is already at the SP2 level) to redistribute with your application, you can either get it through:
To upgrade instances of the Desktop Engine created by using Sqlrun02.msi through Sqlrun16.msi, you must apply the service pack from the SQL Server 2000 Service Pack 2 CD-ROM. You can order this CD-ROM from Microsoft by visiting the Microsoft SQL Server Downloads Web site at:Contact Microsoft Product Support Services (PSS) to obtain the SQL Server 2000 Desktop Engine Service Pack 2 CD-ROM. For a complete list of Microsoft Product Support Services phone numbers and information about support costs, please see the following address on the World Wide Web:

United States Support Options Overview
(http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS)

This service pack includes all of the files required to upgrade existing instances of the Desktop Engine. In addition, it contains the merge modules and .msi files that are required to install a new instance of the Desktop Engine. This CD-ROM is provided for developers who create applications that require the Desktop Engine. For more information, refer to the "Distributing SQL Server Applications" topic in SQL Server 2000 Books Online.

Note The SQL Server 2000 Desktop Engine Service Pack 2 CD-ROM does not include the Service Pack for Microsoft SQL Server 2000 or Analysis Services.

The procedure for upgrading an existing installation of the Desktop Engine varies depending on which of the three versions of the SQL Server 2000 Desktop Engine SP2 software you use, and the medium (for example, CD-ROM or network share) from which you perform the upgrade. When you upgrade the Desktop Engine, you must apply the Desktop Engine service pack to every instance of the Desktop Engine.

Properties

Article ID: 315721 - Last Review: January 21, 2013 - Revision: 3.0

kbinfo KB315721

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.