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
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?
1
0
“The user associated with the DSN has insufficient privileges”
https://kb.vmware.com/selfservice/microsites/search.do?cmd=displayKC&docType=kc&externalId=2114754&sliceId=1&docTypeID=DT_KB_1_1&dialogID=478318970&stateId=1%200%20478328875
1
0
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
1
1
IS C
https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2006904
1
0
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.”
1
0
C
0
0
BTW, part of the new 125Q VMware 2V0-622PSE dumps are available here:
https://drive.google.com/open?id=0B-ob6L_QjGLpaXhnQWQ4S2Ffc1k
Best Regards!
0
0