You must provide Site Recovery Manager with a system database source name (DSN) for a 64-bit open database connectivity (ODBC) connector. The ODBC connector allows Site Recovery Manager to connect to the Site Recovery Manager database.

About this task

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.

Prerequisites

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

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 or SQL Server Native Client 11.0.

    Oracle Server

    Select Microsoft ODBC for Oracle.

  4. (Optional) : Create an SQL Server data source for the database.
    1. 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.

    2. Select the authentication method that corresponds to the type of database user account that you created and click Next.
    3. 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.

Results

The ODBC driver for your database is ready to use.