"Incompatible MSSQL version with vCenter Server 6.0" while upgrading from vCenter Server 5.0 to 6.0
search cancel

"Incompatible MSSQL version with vCenter Server 6.0" while upgrading from vCenter Server 5.0 to 6.0

book

Article ID: 338819

calendar_today

Updated On:

Products

VMware vCenter Server

Issue/Introduction

Symptoms:
  • Upgrading from  vCenter Server 5.0 to 6.0 fails with the error:

    Incompatible MSSQL version with vCenter Server 6.0
  • Pre-upgrade script fails with the error:

    Incompatible MSSQL version with vCenter Server 6.0
     
  • Cannot upgrade from vCenter Server 5.0 that runs with an embedded database and reinstalled in the past to vCenter Server 6.0.

    Note: Upgrading from vCenter 5.0 with embedded database to vCenter 6.0 is supported.
     
  • Upgrading vCenter Server from version 5.0 to 6.0 fails.
  • In the CollectRequirements_com.vmware.vcdb_date.log file, in the installation log bundle, you see entries similar to:

    <YYYY-MM-DD>T<time> INFO vcdb VCDB: external
    <YYYY-MM-DD>T<time> INFO vcdb DB type: external
    <YYYY-MM-DD>T<time> INFO vcdb Validating source external schema...
    <YYYY-MM-DD>T<time> ERROR vcdb Error while validating source vCenter Server database: ERROR: Incompatible MSSQL version with vCenter Server 6.0</time></time></time></time>


Environment

VMware vCenter Server 6.0.x
VMware vCenter Server 5.0.x

Cause

This issue occurs if you have reinstalled vCenter 5.0 with Use Existing DB option. This changes the registry key DbServerType from Bundled to Custom.

Resolution

To resolve this issue, change DbServerType value from Custom to Bundled.
  1. Click Start > Run, type regedit, and click OK. The Registry Editor window opens.
  2. Take a backup of the registry.
  3. Navigate to HKEY_LOCAL_MACHINE > SOFTWARE > VMware, Inc > VMware VirtualCenter
  4. Modify the DbServerType key and change the Value data from Custom to Bundled
  5. Click OK
  6. Click Start > Run, type cmd, and click OK. The Command Prompt window opens.
  7. Navigate to the vCenter Server installation directory. The default location is C:\Program Files\VMware\Infrastructure\VirtualCenter Server
  8. Run this command

    vpxd.exe -p
     
  9. Enter the database password when prompted.
  10. Restart the vCenter Server service.
  11. Start the vCenter Server 6.0 upgrade.


Additional Information

For an embedded DB in the CollectRequirements_com.vmware.vcdb_date.log file, you see entries similar to:
 
<YYYY-MM-DD>T<time> INFO vcdb DB type: embedded</time>
<YYYY-MM-DD>T<time> INFO vcdb Validating source embedded schema...</time>
<YYYY-MM-DD>T<time> INFO vcdb Souce embedded schema validation completed</time>

For more information, see:


Powered by Wolken Software