Home » VMware » VCP550D » Which configuration setting could be causing the issue?
An administrator needs to install vSphere Update Manager using an external SQL Server 2008 R2 database. The administrator has created the database successfully, but cannot establish connectivity when testing the DSN.
Which configuration setting could be causing the issue?
A. The database was configured to use Windows authentication.
B. The DSN was configured using a 32-bit ODBC connection.
C. Update Manager does not support the use of a remote database.
D. Port 9087 is being blocked by Windows Firewall on the Update Manager server.
Correct Answer: A
Explanation/Reference:
Explanation:
In this question, Update Manager is using an external SQL Server database. If an external SQL Server database is being used, you must use the SQL Server authentication method.
Update Manager does not support Windows authentication of the database when the database is located on a different machine because of local system account issues. Make sure that if the Update Manager database is located on a remote machine, the database and the system DSN use SQL Server authentication.
Incorrect Answers:
B: The DSN should be configured using a 32-bit ODBC connection. Therefore, this answer is incorrect.
C: Update Manager does support the use of a remote database. Therefore, this answer is incorrect.
D: The vCenter Update Manager Client plug-in connects to the vCenter Update Manager Web server on HTTP (SSL) port 9087 for uploading the host upgrade files. Port 9087 is not used for connections to the SQL Server database. SQL Server uses port 1433, not port 9087. Therefore, this answer is incorrect.
References:
http://pubs.vmware.com/vsphere-55/index.jsp?topic=%2Fcom.vmware.vsphere.update_manager.doc%2FGUID-132F07F5-46FB-4AAC-A0EC-162893F571BB.html