What could cause this error?

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?

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?

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

Explanation:
https://pubs.vmware.com/vsphere-50/index.jsp?topic=%2Fcom.vmware.vsphere.install.doc_50%
2FGUID-5AA32F87-270C-4171-8896-41A607F8F997.html

Show Hint

Leave a Reply 9

Your email address will not be published. Required fields are marked *

cooldownearth

cooldownearth

https://docs.vmware.com/en/VMware-vSphere/6.5/com.vmware.vsphere.install.doc/GUID-5AA32F87-270C-4171-8896-41A607F8F997.html

BTW does anyone know how the message would look like if it was D?

Reply

blackjack676

blackjack676

The small but big difference is between “upgrading” and “installing”.

If the question would begin with “Installing vCenter Server…” the answer would be D. See KB https://kb.vmware.com/s/article/2083879

Reply

SPFC

SPFC

Weird error message indeed but the answer is C

“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.”

Reply

Aedan Glasby

Aedan Glasby

New VMware 2V0-622PSE Exam Questions Updated Recently (18/Sep/2017):

NEW QUESTION 1
An administrator is creating VMkernel adapters on an ESXi 6.5 host and wants to create separate VMkernel adapters for every type of traffic in the default TCP/IP stack. Which three types of traffic can be explicitly enabled on a separate VMkernel adapter? (Choose three.)

A. Virtual SAN traffic
B. NFS traffic
C. vMotion traffic
D. vSphere HA traffic
E. Fault Tolerance logging traffic

Answer: CDE

NEW QUESTION 2
Which Host Profile Subprofile configuration is used to configure firewall settings for ESXi hosts?

A. Advanced Configuration Settings
B. General System Settings
C. Security
D. Networking

Answer: A

NEW QUESTION 3
An administrator has decided to use Auto Deploy in the environment. Which two considerations must be taken into account before configuring Auto Deploy? (Choose two.)

A. Hosts in a cluster must be connected to a Distributed Switch.
B. Host profiles are not supported when using Auto Deploy.
C. DHCP must be configured to support PXE boot.
D. Storage DRS must be enabled.
E. A TFTP server must be setup and running.

Answer: CE

NEW QUESTION 4
Which two permissions are required to migrate a virtual machine with Storage vMotion? (Choose two.)

A. Network > Move Network
B. VirtualMachine > Inventory > Move
C. Resource > Migrate powered on virtual machine
D. Datastore > Allocate Space

Answer: CD

NEW QUESTION 5
Which are two vCenter Server two-factor authentication methods? (Choose two.)

A. RSA SecurID
B. Smart Card
C. SAML
D. Symantec VIP

Answer: AB

NEW QUESTION 6
Which is the block size on the VMFS6 datastore?

A. All small and large file blocks are 8MB.
B. All small and large file blocks are 1MB.
C. Small file blocks are 512KB, large file blocks are 64MB.
D. Small file blocks are 1MB, large fileblocks are 512MB.

Answer: B

NEW QUESTION 7
An administrator would like to configure vSphere HA to use two isolation addresses. How would this affect the behavior of HA?

A. If both isolation addresses are not reachable, the host will be restarted by the HA agent.
B. If both isolation addresses are not reachable, the host will use the vCenter Server IP address as a final isolation address before being marked isolated.
C. If only one of the isolation addresses is reachable, the host will not be marked isolated by HA.
D. If only one of the isolation addresses is reachable, the host will be considered in an isolated by HA.

Answer: C

NEW QUESTION 8
An administrator notices that a virtual machine running SQL Server is not performing as expected:
vmware.log> vmx| W110: NUMA and VCPU hot add are incompatible. Forcing UMA
How can the administrator resolve this issue?

A. Power off the virtual machineand disable vCPU hot plug.
B. Reinstall VMware Tools.
C. Modify the .vmx file to force NUMA and vCPU hot add to function.
D. Installation third party plug-in to enable NUMA and vCPU hot add to function.

Answer: A

NEW QUESTION 9
……

P.S. These New VMware 2V0-622PSE Exam Questions Were Just Updated From The Real VMware 2V0-622PSE Exam, You Can Get The Newest VMware 2V0-622PSE Dumps In PDF And VCE From — https://www.passleader.com/2v0-622pse.html (125q VCE and PDF)

Good Luck!

Reply