Article ID: 315721
This article has been archived. It is offered "as is" and will no longer be updated.
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.
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).
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: