An administrator is installing View Composer on an existing vCenter Server system. The databases are stored on a separate virtual machine running Microsoft SQL Server. A service account has been created in Active Directory and granted administrator and database owner rights.
During the installation, clicking the Test Connection button in the ODBC entry is successful but View Composer cannot connect to the database and the install will not continue.
What is the cause of this problem?
A.
The DNS entry for the database server is missing or incorrect.
B.
The firewall on the SQL server is blocking traffic on port 1433.
C.
Windows authentication is not supported when the database is on a separate server.
D.
The password used by the ODBC connection does not meet the complexity rules defined in the SQL Server security configuration.