2V0-621 · 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 database permission error during upgrade is caused by either incorrect database user permissions or the database operating in an unsupported 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
(31 responses)- A74% (23)
- C16% (5)
- D10% (3)
Why each option
The vCenter database permission error during upgrade is caused by either incorrect database user permissions or the database operating in an unsupported compatibility mode.
When the SQL Server database is configured with an unsupported compatibility level (for example, an older SQL Server compatibility mode), the vCenter installer cannot execute the required schema and stored procedure operations, producing this permissions-related error even if the account itself has been granted privileges.
The error message explicitly states the DB user does not have the required permissions, meaning the database account has not been granted the necessary roles such as db_owner or specific DDL permissions needed by the vCenter installer to create and configure the schema.
The error refers specifically to database-level permissions for the DB user, not to vCenter Server application-level or Windows service account permissions.
If the database server service had stopped, the installer would return a connection failure or timeout error, not a permissions-related error message.
Concept tested: vCenter Server database user permissions and compatibility mode
Source: https://docs.vmware.com/en/VMware-vSphere/6.7/com.vmware.vcenter.install.doc/GUID-overview.html
Topics
Community Discussion
No community discussion yet for this question.