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.
Explanation:
A is correct
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.
http://pubs.vmware.com/vsphere-50/index.jsp#com.vmware.vsphere.update_manager.doc_50/GUID-132F07F5-46FB-4AAC-A0EC-162893F571BB.html
The above link concerns Update Manager 5.0 but also applies to Update Manager 5.5:
http://pubs.vmware.com/vsphere-55/index.jsp#com.vmware.vsphere.update_manager.doc/GUID-132F07F5-46FB-4AAC-A0EC-162893F571BB.html
Update Manager では、データベースが別のマシン上にある場合、ローカル システム アカウントの問題によりデータベースの Windows 認証をサポートしません。Update Manager データベースがリモート マシン上にある場合、データベースとシステム DSN が SQL Server 認証を使用することを確認します。
http://pubs.vmware.com/vsphere-50/index.jsp?topic=%2Fcom.vmware.vsphere.update_manager.doc_50%2FGUID-132F07F5-46FB-4AAC-A0EC-162893F571BB.html