5.5

Table Of Contents
Alternatively, you can create an ODBC system DSN by running the Windows ODBC Administrator tool
during the SRM installation process.
Prerequisites
You created the database instance to connect to SRM.
Procedure
1 Double-click the Odbcad32.exe file at C:\Windows\System32 to open the 64-bit ODBC Administrator tool.
IMPORTANT Do not confuse the 64-bit Windows ODBC Administrator tool with the 32-bit ODBC
Administrator tool located in C:\Windows\SysWoW64. Do not use the 32-bit ODBC Administrator tool.
2 Click the System DSN tab and click Add.
3 Select the appropriate ODBC driver for your database software and click Finish.
Option Action
SQL Server
Select SQL Server Native Client 10.0.
Oracle Server
Select Microsoft ODBC for Oracle.
4 (Optional) Create a SQL Server data source for the database.
a Provide the details for the data source.
Option Action
Name
Type a name for this data source, for example SRM.
Description
Type a description of the data source, for example SRM.
Server
Select the running database instance to which to connect or type the
address of the database server.
b Select the authentication method that corresponds to the database that you created and click Next.
c Click Next to retain the default settings for this database connection and click Finish.
5 (Optional) Create an Oracle Server data source for the database and click Next.
Option Action
Data Source Name
Type a name for this data source, for example SRM.
Description
Type a description of the data source, for example SRM.
TNS Service Name
Type the address of the database server in the format
database_server_address:1521/database_name.
User ID
Type the database user name.
6 Click Test Data Source to test the connection and click OK if the test succeeds.
If the test does not succeed, check the configuration information and try again.
7 Click OK to exit the Windows ODBC Administrator tool.
The ODBC driver for your database is ready to use.
Chapter 3 Creating the SRM Database
VMware, Inc. 25