You must provide Site Recovery Manager with a database source name (DSN) for a 64-bit open database connectivity (ODBC) system.

You can create the ODBC system DSN before you run the Site Recovery Manager installer by running Odbcad32.exe, the 64-bit Windows ODBC Administrator tool.

Alternatively, you can create an ODBC system DSN by running the Windows ODBC Administrator tool during the Site Recovery Manager installation process.

You created the database instance to connect to Site Recovery Manager.

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.

You can also start the 64-bit ODBC Administrator tool from Control Panel > Administrative Tools > Data Sources (ODBC).

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.

DB2

Select Microsoft ODBC for DB2.

4

Provide the information to create a new data source for the database and click Next.

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.

5

Select the authentication method that corresponds to the database that you created and click Next.

6

Click Next to retain the default settings for this database connection.

7

Click Test Data Source to test the connection and click OK if the test succeeds.

8

Click OK to exit the Windows ODBC Administrator tool.

The ODBC driver for your database is ready to use.