Problem: After successfully configuring SQL server 2008, installing vCenter single sign-on, I could not get thru installing vCenter server. I created the ODBC connection with the tests running successfully. Still during the vCenter install, I could not connect to a supporting database.
Realization: The SQL native client needed to be installed first...then recreate a new ODBC connection to the backend SQL database before proceeding with vCenter server installation.
Before you proceed with installing vCenter Server, you need to install SQL Native Client. This is located on the SQL ISO (the one you installed SQL Server on @ SQL VM). It can be found in folder 1033_enu_lp\x64\setup\x64and is called sqlncli.msi.
The installation is just a matter of Next, Next, Next, Finish
