Search the VMware Knowledge Base (KB)
View by Article ID

Upgrading VMware Update Manager to version 5.0 Update 1 fails while updating SQL Express instance (2020741)

  • 4 Ratings

Symptoms

  • Attempting to update VMware Update Manager to version 5.0 Update 1 fails while updating the SQL Express instance.
  • Upgrading VMware Update Manager 4.x or 5.0 to VMware Update Manager 5.0 Update 1 fails.
  • The setup fails while updating the SQL Server Express instance.
  • In the %TEMP%/vminst.log file, you may see messages similar to:

    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> Setting property SQLEXP_UPGRADE_REQUIRED =
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> Getting Property MSDE_INSTANCE = VIM_SQLEXP
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME>Getting Property SQL_EXP_VERSION = 10.50.2500.0
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> Version 10.50.2500.0 newer than 10.50.1600.1
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> Setting property SQLEXP_UPGRADE_REQUIRED = 1
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> ---------- End Logging----------
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> ---------- Begin Logging ----------
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> --- CA exec: VMUpgradeMsde
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> Getting Property SourceDir = E:\updateManager\
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> Getting Property TempFolder = C:\Users\ADM_NI~1\AppData\Local\Temp\2\
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> Getting Property MSDE_INSTANCE = VIM_SQLEXP
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME>Getting Property VersionNT64 = 601
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> Found "E:\updateManager\..\redist\SQLEXPR\SQLEXPR_x64_ENU.exe"
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> Attempting to launch "E:\updateManager\..\redist\SQLEXPR\SQLEXPR_x64_ENU.exe /QS /ACTION=patch /IACCEPTSQLSERVERLICENSETERMS /INSTANCENAME=VIM_SQLEXP"
    VMware Update Manager-build-639867: <YYYY-MM-DD>T<TIME> Process returned 2226323458
  • In the %TEMP%/SqlSetup.log file, you see messages similar to:

    <YYYY-MM-DD>T<TIME>.392 Attempting to run user requested action from media setup100.exe
    <YYYY-MM-DD>T<TIME>.392 Attempting to launch process d:\a6c5110e0f33cc5a502f86848c5e81\x64\setup100.exe
    <YYYY-MM-DD>T<TIME>.741 Process returned exit code: 0x84B30002
    <YYYY-MM-DD>T<TIME>.787 Media setup100.exe returned exit code: 0x84B30002
  • The installed version of SQL Server Express is 10.50.2500.0, which is the same as the redistributable version bundled with vSphere 5.0 Update 1.

    Note: This can be checked with SQL Management Studio. Right-click the SQL Server instance and click Properties to verify the version.

Cause

This issue can occur if the version information for SQL Server Express in the registry is incorrect. The vSphere installer checks this registry key and compares it to the version string of the bundled SQL Express setup:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\VIM_SQLEXP\MSSQLServer\CurrentVersion
 
If these version strings do not match, the vSphere installer attempts to upgrade the database even though the database version is already up to date.

Resolution

To resolve this issue:

Note: Before making any Windows registry modifications, ensure that you have a current and valid backup of the registry and the virtual machine. For more information on backing up and restoring the registry, see the Microsoft article 136393.

  1. Click Start > Run, type regedit, and press Enter. The Registry Editor window opens.
  2. Navigate to:

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\VIM_SQLEXP\MSSQLServer\CurrentVersion

  3. Change the value of the key to match the version string of the redistributable Microsoft SQL Express installer. For example, the version string is 10.50.2500.0 for SQL 2008 R2 SP1 Express.
  4. Click OK and close the Registry Editor.
  5. Update VMware Update Manager again to verify.

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 4 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 4 Ratings
Actions
KB: