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.
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)- A11% (4)
- B3% (1)
- C84% (32)
- D3% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.