nerdexam
Broadcom-VMware

2V0-622PSE · Question #329

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…

The correct answer is C. incorrect compatibility mode on the SQL server. This issue occurs when the vCenter Server instance being upgraded is connected to a SQL server which was upgraded and the vCenter Server database compatibility level is not changed to match the SQL server version.

Section 4 – Upgrade vSphere 6.x to vSphere 6.5

Question

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?

Options

  • Aincorrect ports open on SQL Server
  • Bincorrect database on the SQL server
  • Cincorrect compatibility mode on the SQL server
  • Dincorrect permission on SQL Server database

How the community answered

(43 responses)
  • A
    14% (6)
  • B
    2% (1)
  • C
    77% (33)
  • D
    7% (3)

Explanation

This issue occurs when the vCenter Server instance being upgraded is connected to a SQL server which was upgraded and the vCenter Server database compatibility level is not changed to match the SQL server version.

Topics

#vCenter upgrade#SQL Server compatibility mode#database prerequisites#upgrade troubleshooting

Community Discussion

No community discussion yet for this question.

Full 2V0-622PSE Practice