Microsoft KB Archive/831862

= Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A =

Article ID: 831862

Article Last Modified on 11/27/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2000 Desktop Engine (MSDE) Release A

-



Article Contents

 * Summary
 * Introduction
 * More Information
 * The differences between MSDE 2000 Release A and MSDE 2000 SP3a
 * How to upgrade earlier versions of MSDE
 * How to distribute MSDE 2000 Release A
 * Version information
 * The ReadmeMSDE2000A.htm file
 * How to download MSDE 2000 Release A



SUMMARY
''Currently, Microsoft is re-releasing Microsoft SQL Server Desktop Engine 2000 Service Pack 3a (SP3a) as Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A. This article addresses the changes and the differences between SQL Server Desktop Engine 2000 SP3a and MSDE 2000 Release A.

Please leverage public newsgroups for free support; otherwise, you may incur support charges.''



INTRODUCTION
Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A is an updated, downloadable version of MSDE 2000. The updated version has a new End-User License Agreement (EULA) that gives users different rights from previous MSDE 2000 licenses.

After you download and extract the MSDE 2000 Release A files, you use the Desktop Engine Setup.exe file to install instances of MSDE 2000 Release A. Desktop Engine Setup.exe is a command prompt utility; it does not have a user interface. Instead of using a user interface to specify installation options, you use command prompt switches, or you use an .ini file.



The differences between MSDE 2000 Release A and MSDE 2000 SP3a
After you install MSDE 2000 Release A, it functions the same as MSDE 2000 Service Pack (SP) 3a. The following is a list of the differences between MSDE 2000 Release A and MSDE 2000 SP3a.


 * MSDE 2000 Release A has a new EULA.
 * MSDE 2000 Release A cannot be used to upgrade earlier versions of MSDE.
 * MSDE 2000 Release A does not include the merge modules that are sometimes used to embed earlier versions of MSDE 2000 in application setup utilities.
 * The ReadmeMSDE2000A.htm file is new.

How to upgrade earlier versions of MSDE
MSDE 2000 Release A can only be used to install new instances of MSDE 2000 Release A. If you want to upgrade earlier versions of MDSE, you must use the MSDE part of the SQL Server 2000 service pack files. You use the SQL Server 2000 service pack files to do the following:
 * Upgrade MSDE 1.0 to MSDE 2000.
 * Apply the latest service pack to an instance of MSDE 2000. For example, use the MSDE part of Microsoft SQL Server 2000 SP3a to upgrade instances of MSDE 2000 Service Pack 1 (SP1) or to upgrade MSDE 2000 Service Pack 2 (SP2) to MSDE 2000 SP3a.

To download the latest SQL Server 2000 service pack files, visit the following Microsoft Web site:

http://technet.microsoft.com/en-us/sqlserver/bb331754.aspx

How to distribute MSDE 2000 Release A
MSDE 2000 Release A does not include the merge modules that are sometimes used to embed earlier versions of MSDE 2000 in application setup utilities. To distribute the MSDE 2000 Release A files with applications, you must write an application setup wrapper utility that does the following:
 * Calls the Desktop Engine Setup.exe file to install an instance of MSDE 2000 Release A.
 * Installs the application.

For more information about distributing MSDE 2000 Release A, visit the following Microsoft Web site:

http://www.microsoft.com/sql/prodinfo/previousversions/msde/msdeuse.mspx

Version information
MSDE 2000 Release A contains the same fixes as MSDE 2000 SP3a, including the fixes that address issues that were raised by the Slammer worm. You do not have to apply MSDE 2000 SP3a to MSDE 2000 Release A. You also do not have to upgrade MSDE 2000 SP3a or MSDE 2000 Service Pack 3 (SP3) to MSDE 2000 Release A.

MSDE 2000 Release A returns the same version information as MSDE 2000 SP3a. If you use the @@VERSION system variable or the SERVERPROPERTY('ProductVersion') function, both report a build number of 8.00.760. The SERVERPROPERTY('ProductLevel') function returns SP3. Both the @@VERSION system variable and the SERVERPROPERTY('Edition') function report the edition as Desktop Engine.

The ReadmeMSDE2000A.htm file
To download the readme file for MSDE 2000 Release A, visit the following Microsoft Web site:

http://download.microsoft.com/download/d/5/4/d5402c33-65de-4464-9d82-d1de2971d9db/ReadmeMSDE2000A.htm

For information about additions to the ReadmeMSDE2000A.htm file, see the following article in the Microsoft Knowledge Base:

829925 Additions to the SQL Server 2000 Desktop Engine (MSDE) Release A ReadmeMSDE2000A.htm File

How to download MSDE 2000 Release A
To download MSDE 2000 Release A, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en

Additional query words: MSDE SQL Server Desktop Engine Redistribute

Keywords: kbdatabase KB831862

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.