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
Correct C
https://kb.vmware.com/s/article/2006904
6
0
Correct C
https://kb.vmware.com/s/article/2006904
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.
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?
“The user associated with the DSN has insufficient privileges” – error messafe: “
Error : 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
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 – error „The database user ‘username’ does not have the following privileges on the ‘databasename’”
5
0