VMware vSphere 6.5 Professional (2017) — Question 11

Upgrading vCenter Server with Microsoft SQL database fails with the following error message:
The DB User entered does not have the required permissions needed to install and configure vCenter Server with the selected DB. Please correct the following error(s): %s
What could cause this error?

Answer options

• A. incorrect ports open on SQL Server
• B. incorrect database on the SQL server
• C. incorrect compatibility mode on the SQL server
• D. incorrect permission on SQL Server database

Correct answer: C

Explanation

The correct answer is C because the compatibility mode needs to match the requirements for vCenter Server to function properly with the database. If the compatibility mode is incorrect, it can lead to permission issues during the installation. Options A, B, and D do not directly relate to the permissions required for the DB User, making them less likely causes of this specific error.