"Incompatible SQL version with vCenter Server 6.0" error when installing/upgrading VC
search cancel

"Incompatible SQL version with vCenter Server 6.0" error when installing/upgrading VC

book

Article ID: 321050

calendar_today

Updated On:

Products

VMware vCenter Server

Issue/Introduction

Symptoms:
When attempting to install or upgrade vCenter Server 5.x to vCenter Server 6.x, you may experience any one of the below symptoms:
 
  • The pre-install validation fails.
  • While upgrading to vCenter 6.0, you will see below error if you are using SQL Developer Edition (64-bit)
  • Error: Incompatible source vCenter Server database version. Resolution: Make sure your database version meets vCenter Server database requirements.
  • An incompatible SQL Server version was detected.
  • You see the error:
    %temp%\vminst.log file, you see entries similar to:

    <YYYY-MM-DD>T<time>| vcsInstUtil-2562624| I: PitCA_MessageBox: Displaying message: "Error: Source vCenter Server validation found an issue: ERROR: Incompatible MSSQL version with vCenter Server 6.0</time> Resolution: Make sure your database is configured to meet vCenter Server upgrade requirements."
     
  • In the C:\ProgramData\VMware\vCenterServer\logs\firstboot\CollectRequirements_com.vmware.vcdb_date.log file, you see entries similar to:

    <YYYY-MM-DD>T<time> ERROR vcdb Error while validating source vCenter Server database: ERROR: Incompatible MSSQL version with vCenter Server 6.0

    </time>
Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment.


Environment

VMware vCenter Server 6.0.x

Cause

This issue occurs if the vCenter Server database resides on an Microsoft SQL instance that does not meet the requirements for vCenter Server 6.0. For more information on supported databases, see VMware Product Interoperability Matrixes.

Resolution

To resolve this issue, verify the compatibility level of the supported SQL database:
 
For more information on database compatibility, see VMware Product Interoperability Matrixes.
  • To verify the MSSQL version, compatibility level, and addition using a SQL query:
  1. Open the MSSQL Management Studio and connect to the SQL Server that vCenter Server database resides on.
  2. Run the this query on the vCenter Server database to verify the version, level and edition:

    SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
     
  3. Ensure that the vCenter Server database compatibility is set to SQL Server 2008 or higher. For more information on versions, see the Microsoft Knowledge Base article 321185.
  • To verify the database compatibility level using the MSSQL Management Studio:
  1. Open the MSSQL Management Studio and connect to the SQL Server the vCenter database resides on.
  2. Expand database.
  3. Right-click on the vCenter Server database instance and then click properties.
  4. Select Options.
  5. Ensure Compatibility level is set to the version of MSSQL Server currently connected to.

    Note: Compatibility maybe set to a lower level if the database was previously migrated from an older version of MSSQL.
  • If you get an error regarding 'not have enough permission', then make sure VCDB has sysadmin permission.
To work around this issue if you are using SQL Server 2008 R2 SP1 or SP2 Datacenter Edition, move the database to a non-Datacenter Edition (such as Enterprise). vCenter Server can then be installed using the non-Datacenter Edition of Microsoft SQL Server. For more information on database migration, see Copy Databases to Other Servers.

Additional Information

For information on migrating the vCenter Server's SQL database, see