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.)
A.
The database is set to an unsupported compatibility mode.
B.
The permissions for the database are incorrect.
C.
The permissions for vCenter Server are incorrect.
D.
The database server service has stopped.
Explanation:
Explanation/Reference:
A and B are correct.
http://pubs.vmware.com/vsphere-60/index.jsp?topic=%2Fcom.vmware.vsphere.upgrade.doc%2FGUID-5AA32F87-270C-4171-8896-41A607F8F997.html&resultof=%22%25%73%22%20
Below the explanation for the B answer:
https://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=2083879
That KB is concerned with initial installation, do you think that is the same for upgrading, what the question asks?
yes, this addresses upgrade & includes both Permissions and compatibility..
https://kb.vmware.com/kb/2006904
*You have verified and ensured that the user account used to perform the upgrade has sufficient administrative privileges.
*To resolve this issue, change the database compatibility level to match the SQL Servers level.