nerdexam
Broadcom-VMware

2V0-622D · Question #196

Upgrading vCenter Server with Microsoft SQL database fails with the following error message: What could cause this error?

The correct answer is C. incorrect compatibility mode on the SQL Server. A vCenter Server upgrade against a Microsoft SQL database fails when the SQL Server database compatibility level is set to a value outside the range supported by the target vCenter version.

Section 4 – Upgrade vSphere 6.x to vSphere 6.5

Question

Upgrading vCenter Server with Microsoft SQL database fails with the following error message:

What could cause this error?

Options

  • Aincorrect database on the SQL Server
  • Bincorrect ports open on SQL Server
  • Cincorrect compatibility mode on the SQL Server
  • Dincorrect permission on SQL Server database

How the community answered

(38 responses)
  • A
    11% (4)
  • B
    3% (1)
  • C
    84% (32)
  • D
    3% (1)

Why each option

A vCenter Server upgrade against a Microsoft SQL database fails when the SQL Server database compatibility level is set to a value outside the range supported by the target vCenter version.

Aincorrect database on the SQL Server

An incorrect or missing database name would produce a database-not-found or connection string error during the initial installer checks, not a compatibility mode failure mid-upgrade.

Bincorrect ports open on SQL Server

Incorrect ports would prevent the installer from establishing a TCP connection to SQL Server entirely, resulting in a connectivity timeout error well before any database-level compatibility checks occur.

Cincorrect compatibility mode on the SQL ServerCorrect

vCenter Server's upgrade installer validates that the SQL Server database compatibility level matches the supported range for the vCenter version being installed. If the compatibility level is set too low - for example, to a deprecated SQL Server version level - the installer detects the mismatch and aborts the upgrade with a compatibility mode error, requiring the DBA to alter the database compatibility level before retrying.

Dincorrect permission on SQL Server database

Insufficient database permissions would cause an access denied or privilege error when the installer attempts to read or write schema objects, which is a distinctly different error message and failure mode than a compatibility level mismatch.

Concept tested: vCenter Server upgrade SQL Server database compatibility level requirement

Topics

#vCenter upgrade#SQL database#compatibility mode#upgrade errors

Community Discussion

No community discussion yet for this question.

Full 2V0-622D Practice