How to create ODBC Connection for vCenter and Update Manager

vCenter Server 4.1 installation required 64 bit ODBC connection

We must use a 64 bit DSN for vCenter Server and a 32 bit DSN for VMware Update Manager.

Path of 64 bit DSN for vCenter Server is  

Open the Control Panel --> Administrative Tools --> Open Data Sources ODBC

Path of 32 bit ODBC DSN for Update Manager is  

c:\Windows\System32\odbcad32.exe

First we now need to configure a system DNS entry for vCenter to use:
Open the Control Panel --> Administrative Tools --> Open Data Sources ODBC

1. Click the System DSN tab and click the "Add" button. Select the "SQL Native Client 10.0" driver and click "Finish"

2. Provide a Name to the data source (VCDB), disruption for database (vcenter database) and provide the hostname/IP of the SQL Server(SQL Server name: SQLSERVER) instance you created in the previous section in the Server field

3. Select the "SQL Server authentication" type and provide the login and password created from the "Configuring SQL Server for vCenter" section

4. Change the default database to the database created in the "Configuring SQL Server for vCenter" section (VCDB)

5. Click "Finish" to complete the setup

6. Click the "Test Data Source" button to validate the settings you provided

7. Assuming the test completed successfully, click the "OK" button

8. Click "OK" to complete the test

Creating ODBC Connection for (vCenter update Manager

1. vCenter Update manager required 32 bit DSN ODBC connection.
The path for 32 bit ODBC Connection is c:\Windows\System32\odbcad32.exe

2. Click the System DSN tab and click the "Add" button. Select the "SQL Server" driver and click "Finish".

3. Follow the previous steps from vcenter
Name: VUMDB
Description: vCenter Update Manager
Server: SQLSERVER

4. Select the "SQL Server authentication" type and provide the login and password created from the "Configuring SQL Server for vCenter" section
5. Change the default database to the database created in the "Configuring SQL Server for vCenter" section: (VUMDB)
6. Click "Finish" to complete the setup
7. Click the "Test Data Source" button to validate the settings you provided
8. Assuming the test completed successfully, click the "OK" button
9. Click "OK" to complete the test.