How To Upgrade an instance of Microsoft SQL Server 2000 Desktop Engine to SQL Server 2000 Service Pack 3

Article translations Article translations
Article ID: 815013 - View products that this article applies to.
Notice
Microsoft SQL Server 2000 Service Pack 3a (SP3a) replaces Microsoft SQL Server 2000 Service Pack 3. Because most changes introduced in SQL Server 2000 SP3a are related to setup, you do not have to apply SQL Server 2000 SP3a to instances of SQL Server 2000 or SQL Server Desktop Engine (also known as MSDE 2000) that have already been upgraded to SQL Server 2000 SP3.

However, if you have instances that have not been upgraded to SQL Server 2000 SP3, you must upgrade those instances directly to SQL Server 2000 SP3a instead of SQL Server 2000 SP3. If you have any copies of the SQL Server 2000 SP3 download files that you were planning to use for future upgrades, you must delete those copies and use either the SQL Server 2000 SP3a download files or the SQL Server 2000 SP3a CD-ROM instead.

For applications that distribute and install MSDE 2000, you need to install SQL Server 2000 SP3a instead of SQL Server 2000 SP3. While you can apply SQL Server 2000 SP3a to instances of SQL Server 2000 SP3 or MSDE 2000 SP3, doing so has little effect on those instances. For more information about SQL Server 2000 SP3a, visit the following Microsoft Web site:
SQL Server 2000 Service Pack 3a

For information about how to upgrade an instance of Microsoft SQL Server 2000 Desktop Engine to SQL Server 2000 SP3a, visit the following Microsoft Web site:
SQL Server 2000 Service Pack 3a Readme
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all

On This Page

SUMMARY

This step-by-step article describes how to upgrade an instance of Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) to SQL Server 2000 Service Pack 3 (SP3).

Your computer might have multiple instances of MSDE 2000. Note that you must upgrade each instance of MSDE 2000 separately. The MSDE 2000 instances might have been installed by means of a different mechanism or with a different language. Therefore, each instance might have a different set of upgrade requirements. This article lists the steps that you can use to upgrade each of the MSDE 2000 instances.

For detailed information about installing MSDE 2000 SP3 to an instance of MSDE 2000, read the SQL Server 2000 Service Pack 3 Readme file available from your download files.

Check to See If Your Application Supports MSDE 2000 Service Pack 3

If your instance of MSDE 2000 is being used by an application, contact the provider of the application for support of the MSDE 2000 upgrade.
  • If the application is a Microsoft product, visit the following Microsoft Web site for a list of Microsoft products that include MSDE 2000:

    Microsoft Products That Include MSDE 2000
  • If you use a third-party application, you must contact the respective vendor for any MSDE 2000 upgrade considerations that are specific to that application.

Determine What Download File to Use to Upgrade an Instance of MSDE 2000 to Service Pack 3

To determine how to patch an instance of MSDE 2000, you have to know how the instance was installed. To determine how an instance was installed, you can use the information that was recorded as a ProductCode entry in a registry key.

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
311762 INF: How to Identify Which MSI File Was Used for an Existing MSDE Installation
  • If the original package name for the ProductCode value was SqlRun01.msi through SqlRun16.msi, you can upgrade your instance of MSDE 2000 by using the SQL Server 2000 Desktop Engine SP3 download files.
  • If the original package name for your ProductCode value is Sample.msi or SampleUpg.msi, see the following article in the Microsoft Knowledge Base:
    314131 How To Create Patch Files for the MSDE 2000 Sample.msi File
  • If the original package name for your ProductCode value refers to a Microsoft application, visit the following Microsoft Web site for instructions on how to upgrade that instance of MSDE 2000:

    Microsoft Products That Include MSDE 2000
  • If the ProductCode value is not listed in the article, the instance was installed by the setup utility of an application. You cannot use the SQL Server 2000 Desktop Engine SP3 download files to apply SP3 to such MSDE instances. Instead, you must contact the respective vendor for a patch file. If the application was developed by Microsoft, visit the following Microsoft Web site. The site lists the MSDE applications from Microsoft:

    Microsoft Products That Include MSDE 2000

Determine the Language of the MSDE 2000 Instance

To download the Service Pack 3 file, you must know the language (such as English or German) that used to install an instance of MSDE 2000. If you are not sure of the language for the MSDE 2000 instance, follow these steps:
  1. Click Start, and then click Run.
  2. In the Open dialog box, type Regedit, and then click OK.
  3. Locate, and then select one of the following keys:

    • For a default instance of MSDE 2000, locate and select this key:

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion
    • For a named instance of MSDE 2000, locate and select this key:

      HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\<InstanceName>\CurrentVersion


      Note: InstanceName is the name of the instance.
  4. In the right screen, read the value of the Language key. Compare that value to the following table to determine the language for your instance of MSDE:

    Collapse this tableExpand this table
    Language registry value (in hexadecimal)Language registry value (in decimal)Language of that instance of MSDE
    0x000004041028Traditional Chinese
    0x000004071031German
    0x00000409 1033English
    0x0000040a 1034Spanish
    0x0000040c 1036French
    0x00000410 1040Italian
    0x00000411 1041Japanese
    0x00000412 1042Korean
    0x00000413 1043Dutch
    0x00000416 1046Brazilian
    0x0000041d 1053Swedish
    0x00000805 2053Simplified Chinese

Download MSDE 2000 Service Pack 3

If your instance of MSDE 2000 was installed by using the MSDE setup utility (original package name SqlRun01.msi through SqlRun16.msi), you can upgrade your instance of MSDE 2000 by using a SQL Server 2000 Desktop Engine SP3 download file:
  1. Visit the following Microsoft Web site to download the setup file:

    SQL Server 2000 Service Pack 3
  2. In the Full Download dialog box, in the upper-right corner of the Web page, select the language that matches the language for your instance of MSDE 2000, and then click Go.
  3. On the next page, locate the Files in this Download section at the bottom of the page. Depending on the language, select one of these files:

    • If you have selected English, download the SQL2KDeskSP3.exe file to a folder on your computer.
    • If you have selected a non-English language, download the file <LANGUAGE_CODE>_SQL2KDeskSP3.exe, where LANGUAGE_CODE represents the language.

Extract MSDE 2000 Service Pack 3 Files

After you download either SQL2KDeskSP3.exe or <LANGUAGE_CODE>_SQL2KDeskSP3.exe, follow these steps to extract the MSDE 2000 SP3 files:
  1. Open Windows Explorer, and then locate the folder that you downloaded the MSDE 2000 SP3 file to.
  2. Double-click the download file to extract the MSDE 2000 SP3 files. Specify a folder where the SP3 files can be extracted.

    Note: This folder will be referred to as C:\ExtractedSP3Folder in the next sections of this article.


Apply MSDE 2000 Service Pack 3

After you extract the MSDE SP3 files to the ExtractedSP3Folder, you can use the MSDE setup utility to apply SP3 to your MSDE 2000 instance.

MSDE 2000 SP3 introduces a new DISABLENETWORKPROTOCOLS setup parameter that turns off the network connection support in an MSDE 2000 instance. If no other application running on other computers connects to an instance of MSDE 2000, turning off the network support can help to make the instance less susceptible to security threats. All the upgrade examples that follow use the DISABLENETWORKPROTOCOLS switch. Specify DISABLENETWORKPROTOCOLS if you are sure that the MSDE 2000 instance will only have to support connections from applications running on the same computer. Do not use this option if the instance must accept connections from applications that are running on other computers.

For additional information about disabling and restoring network access, click the following article number to view the article in the Microsoft Knowledge Base:
814130 How to help secure network connectivity for SQL Server 2000 local databases


When you upgrade an instance of MSDE 2000 that has a null sa password, by default, the MSDE 2000 SP3 setup requests a strong password before it continues with the upgrade. Microsoft recommends that you set a strong password to the sa login before you perform the upgrade, unless the application that is using your instance of MSDE 2000 depends in some way on a null sa password. Even if the instance of MSDE 2000 is running in Windows Authentication mode, a null, simple, or a well-known sa password can be more susceptible to security threats if the instance is switched to Mixed Mode. If you have to assign a strong sa password before you upgrade your instance of MSDE 2000 to SP3, click the following article number to view the article in the Microsoft Knowledge Base:
322336 How To Verify and Change the MSDE System Administrator Password

Warning: Running an instance of MSDE 2000 in mixed mode is less secure than running it in Windows Authentication Mode. Consider changing the instance from Mixed Mode to Windows Authentication Mode if:
  • The applications using MSDE 2000 can run using Windows Authentication.
  • You have defined Windows Authentication logins for all users who have to connect to the instance. For more information about adding logins, visit the following Microsoft Web site:

    Adding a Windows User or Group
  • The instance of MSDE 2000 is not running on a Microsoft Windows 98 or a Microsoft Windows Millennium Edition-based computer.

For additional information about changing an instance of MSDE 2000 from Mixed Mode to Windows Authentication Mode, click the following article number to view the article in the Microsoft Knowledge Base:
322336 HOW TO: Verify and Change the System Administrator Password by Using MSDE

Follow these steps to upgrade an instance of MSDE 2000 to MSDE 2000 SP3:
  1. Click Start, and then click Run.
  2. In the Open dialog box, type cmd.
  3. At the command prompt, use the cd command to located the folder that contains the MSDE 2000 SP3 setup utility. For example:

    cd c:\ExtractedSP3Folder\MSDE

    Note: The C:\ExtractedSP3Folder is the path of the folder where you extracted the MSDE 2000 SP3 files.
  4. Run one of the following commands at the command prompt:

    • For a default instance that is using Windows Authentication Mode, run:

      setup /upgradesp sqlrun DISABLENETWORKPROTOCOLS=1 /L*v <LogFileName>.log
    • For a named instance that is using Windows Authentication Mode, run:

      setup /upgradesp sqlrun INSTANCENAME=<InstanceName> DISABLENETWORKPROTOCOLS=1 /L*v <LogFileName>.log
    • For a default instance that is using Mixed Mode (where AnAdminLogin is a member of the sysadmin fixed server role), run:

      setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=<AnAdminLogin> UPGRADEPWD=<AdminPassword> DISABLENETWORKPROTOCOLS=1 /L*v <LogFileName>.log
    • For a named instance that is using Mixed Mode (where AnAdminLogin is a member of the sysadmin fixed server role), run:

      setup /upgradesp sqlrun INSTANCENAME= <InstanceName> SECURITYMODE=SQL UPGRADEUSER=<AnAdminLogin> UPGRADEPWD=<AdminPassword> DISABLENETWORKPROTOCOLS=1 /L*v <LogFileName>.log


REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
317328 How To Troubleshoot a SQL Server Desktop Engine 2000 Installation and Upgrade
810826 INF: New Switches in MSDE Service Pack 3 Setup
330022 INF: SQL Server 2000 Service Pack 3 Readme.htm Additions

Properties

Article ID: 815013 - Last Review: February 27, 2014 - Revision: 8.5
APPLIES TO
  • Microsoft SQL Server 2000 Desktop Engine (Windows)
  • Microsoft SQL Server 2000 64-bit Edition
Keywords: 
kbnosurvey kbarchive kbupgrade kbsecurity kbregistry kbhowtomaster KB815013

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com