2V0-622 · Question #88
An administrator is upgrading vCenter Server and sees this error: -The DB User entered does not have the required permissions needed to install and configure vCenter Server with the selected DB…
The correct answer is A. The database is set to an unsupported compatibility mode. B. The permissions for the database are incorrect. The vCenter Server installer reports missing DB permissions when either the database user account lacks sufficient rights or the database is running in an unsupported SQL compatibility mode.
Question
An administrator is upgrading vCenter Server and sees this error:
-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 Which two statements explain this error? (Choose two.)
Options
- AThe database is set to an unsupported compatibility mode.
- BThe permissions for the database are incorrect.
- CThe permissions for vCenter Server are incorrect.
- DThe database server service has stopped.
How the community answered
(52 responses)- A79% (41)
- C6% (3)
- D15% (8)
Why each option
The vCenter Server installer reports missing DB permissions when either the database user account lacks sufficient rights or the database is running in an unsupported SQL compatibility mode.
SQL Server databases configured with an older unsupported compatibility mode (such as SQL Server 2000 mode) prevent the vCenter installer from executing required schema operations, which the installer surfaces as a permissions or capability error against the database.
The error message explicitly states the DB user does not have the required permissions - if the database account is missing roles such as db_owner or lacks rights to create and modify schema objects, the installer cannot configure the vCenter database and fails with this error.
The error message refers specifically to the database user credentials entered in the installer, not to vCenter Server's own Windows service account permissions, which are a separate configuration.
A stopped database server service would produce a connection timeout or unreachable host error, not a permissions error about the DB user's rights.
Concept tested: vCenter Server database user permissions and compatibility mode requirements
Source: https://docs.vmware.com/en/VMware-vSphere/7.0/com.vmware.vcenter.install.doc/GUID-BE7788EC-C93C-4B1E-9615-8C97F50D4B19.html
Topics
Community Discussion
No community discussion yet for this question.