Error message when you try to uninstall a SQL Server 2005 Express Edition hotfix package: "1731 The source installation package for the product [2] is out of sync with the client package"

Extended support for SQL Server 2005 ended on April 12, 2016

If you are still running SQL Server 2005, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

SYMPTOMS
When you try to uninstall a Microsoft SQL Server 2005 Express Edition hotfix package, you receive the following error message:
1731 The source installation package for the product [2] is out of sync with the client package. Try the installation again using a valid copy of the installation package '[3]'.
RESOLUTION
To resolve this problem, follow these steps:
  1. Check the Summary.txt file in the %programfiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix directory to see whether the following error is logged:
    1706: Source is invalid due to missing/inaccessible
    If this error is logged, go to step 2.
  2. Determine the version of SQL Server 2005 Express Edition that you are currently running. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
    321185 How to identify your SQL Server version and edition
  3. Save one of the following packages, depending on the version of SQL Server 2005 that you are running. Do not run the package.

    SQL Server 2005 Express Edition Service Pack 2SQL Server 2005 Express Edition with Advanced Services Service Pack 2SQL Server 2005 Express Edition Toolkit Service Pack 2
  4. At a command prompt, extract the package into the following directory:
    %programfiles%\Microsoft SQL Server\90\Setup Bootstrap\Baseline Cache\Edition\SP2
    Note The Edition placeholder represents one of the following values:
    • DESKTOP
    • EXPRESSEXPRESS_ADVANCED
    • EXPRESS_TOOLS
    • STANDARD
    • WORKGROUP
    • ENTERPRISE
    • DEVELOPER
    • PERSONAL
    • EVAL
  5. To extract the package, run a command that resembles the following:
    Name of package /X:Path
    For example, run the following command:
    SQLEXPR.EXE /X:"%programfiles%\Microsoft SQL Server\90\Setup Bootstrap\Baseline Cache\Express\SP2"
    For a 32-bit instance of SQL Server 2005 on an x64-based computer, run the following command:
    SQLEXPR.EXE /X:"%programfiles(x86)%\Microsoft SQL Server\90\Setup Bootstrap\Baseline Cache\Express\SP2"
    For other versions, such as DEVELOPER, the steps are the same. However, the Server folder and the Tools folder must be copied from the SQL Server 2005 disc to the Edition\SP2 folder in this step.
  6. Uninstall the SQL Server 2005 Express Edition hotfix package again.
  7. Delete the cache location that was created in step 4 to prevent Windows Installer from accessing the incorrect media during future installation or uninstallation operations. For example, delete the following folder:
    %programfiles%\Microsoft SQL Server\90\Setup Bootstrap\Baseline Cache\Edition\SP2
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
remove removal delete
Properties

Article ID: 955250 - Last Review: 09/17/2011 08:55:00 - Revision: 4.0

Microsoft SQL Server 2005 Express Edition, Microsoft SQL Server 2005 Express Edition Toolkit, Microsoft SQL Server 2005 Express Edition with Advanced Services

  • kbuninstall kbtshoot kbPubTypeKC kberrmsg kbprb KB955250
Feedback