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

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.

back to the top

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.

back to the top

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:

• 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

back to the top

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:
   
   

   Language registry value (in hexadecimal)	Language registry value (in decimal)	Language of that instance of MSDE
   0x00000404	1028	Traditional Chinese
   0x00000407	1031	German
   0x00000409	1033	English
   0x0000040a	1034	Spanish
   0x0000040c	1036	French
   0x00000410	1040	Italian
   0x00000411	1041	Japanese
   0x00000412	1042	Korean
   0x00000413	1043	Dutch
   0x00000416	1046	Brazilian
   0x0000041d	1053	Swedish
   0x00000805	2053	Simplified Chinese

back to the top

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.

back to the top

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.

back to the top

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:

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:
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:
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

back to the top