Configure a SQL Server ODBC Connection

1)On your vCenter Server system, open the Microsoft Windows ODBC Data Source Administrator.

■On a 32-bit system, select Settings > Control Panel > Administrative Tools > Data Sources (ODBC).
■On a 64-bit system, open C:\WINDOWS\SYSWOW64\odbc32.exe.
2)Select the System DSN tab and do one of the following.

■To modify an existing SQL Server ODBC connection, select the connection from the System Data Source list and click Configure.
■To create a new SQL Server ODBC connection, click Add, select SQL Native Client, and click Finish.

3)Type an ODBC datastore name (DSN) in the Name text box.
For example, VMware vCenter Server.
4)(Optional) Type an ODBC DSN description in the Description text box.
5)Select the server name from the Server drop-down menu and click Next.
Type the SQL Server host name in the text box if it is not in the drop-down menu.
6)Select one of the authentication methods.
7)If you selected SQL authentication, type your SQL Server login name and password and click Next.
8)Select the database created for the vCenter Server system from the Change the default database to menu and click Next.
9)Click Finish.