nerdexam
Broadcom-VMware

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.

Section 4 – Upgrade vSphere 6.x to vSphere 6.x

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)
  • A
    74% (23)
  • C
    16% (5)
  • D
    10% (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.

AThe database is set to an unsupported compatibility mode.Correct

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.

BThe permissions for the database are incorrect.Correct

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.

CThe permissions for vCenter Server are incorrect.

The error refers specifically to database-level permissions for the DB user, not to vCenter Server application-level or Windows service account permissions.

DThe database server service has stopped.

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

#vCenter upgrade#database permissions#compatibility mode#upgrade error

Community Discussion

No community discussion yet for this question.

Full 2V0-621 Practice