Incompatible MSSQL version with vCenter Server 6.0 during install or upgrade

There has been a new issue surfacing when installing or upgrading to vCenter Server 6.0. The error message seems pretty clear: Incompatible MSSQL version with vCenter Server 6.0. If you dive a little bit deeper and look at additional logs like vminst.log or the CollectRequirements_com.vmware.vcdb_date.log you will see the following entries.
 
vminst.log

vcsInstUtil-2562624| I: ParsePreUpgradeOutput: Export disk req: 0 MB, Import disk req: 0 MB.
vcsInstUtil-2562624| I: PitCA_MessageBox: Displaying message: "Error: Source vCenter Server validation found an issue: ERROR: Incompatible MSSQL version with vCenter Server 6.0
 
Resolution: Make sure your database is configured to meet vCenter Server upgrade requirements."

 
CollectRequirements_com.vmware.vcdb_date.log

ERROR vcdb Error while validating source vCenter Server database: ERROR: Incompatible MSSQL version with vCenter Server 6.0

 
It is important that you first make sure to check the Interoperability Matrix to ensure that the database you are using is supported. You will need to check the radio box Solution/Database Interoperability and select both VMware vCenter Server and 6.0 from the drop down boxes.
 
1
 
Note: These are not all-inclusive, I just took the top several rows as an example.
 
You also want to check the database version, and compatibility level; you can do this by running the SQL query below or by using the GUI. You will want to ensure that the compatibility is set to SQL Server 2008 or higher.
 

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

 
2
 
Step 1. Open Microsoft SQL Server Management Studio expand Databases Right Click and select Properties
 
3
 
Step 2. Select Options and Ensure the compatibility level is set to SQL Server 2008 or higher
 
4
 
After you change the compatibility level, you should be able to re-run the install or upgrade successfully!
 

Posted by:

Sean Whitney

5 Comments

  1. David -  October 30, 2015 - 3:58 am 318

    Hello Sean,

    We are planning to upgrade our ESXi hosts where our SQL 2008 R2 SP1 virtual machines cluster are hosted to vSphere 6U1. Do you know if this upgrade is supported by Microsoft?

    Thanks
    David

    Reply
    • Sean Whitney -  October 30, 2015 - 4:47 pm 319

      Hi David,

      I am not sure, your best bet is to contact Microsoft to confirm.

      Sean

      Reply
  2. john -  March 12, 2016 - 1:41 am 439

    Hi Sir I am experiencing this issue right now when upgrading our vcenter server 5.5 to 6.0.
    I already set the database compatibility level to SQL server 2008 (100) and still the upgrade won’t continue.

    Reply
  3. john -  March 13, 2016 - 6:28 am 440

    Hi Experts,

    I am trying to upgrade our VCenter Server 5.5 update 3 to 6.0, but got this error “incompatible source vCenter Server database version”.
    I already set the database compatibility level to SQL server 2008 (100) but no luck same error prompted

    Hope you can help me on this.

    -John

    Reply
    • Brian -  June 29, 2017 - 2:29 pm 596

      John,
      Same issue here.
      Let me know if anything changes.
      -Brian

      Reply

Leave A Comment

Your email address will not be published. Required fields are marked (required):

Back to Top