Create an ODBC System DSN for Site Recovery Manager

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.

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.

Note: If you use the embedded Site Recovery Manager database, the Site Recovery Manager installer creates the ODBC system DSN according to the information that you provide during installation. If you uninstall the embedded database, the uninstaller does not remove the DSN for the embedded database. The DSN remains available for use with a future reinstallation of Site Recovery Manager.

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, SQL Server Native Client 11.0, or ODBC Driver 11 for SQL Server.
   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	Enter a name for this data source, for example SRM.
      Description	Enter a description of the data source, for example SRM.
      Server	Select the running database instance to which to connect or enter 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.
      If you select Integrated Windows Authentication, you must use the same user account, or an account with the same privileges on the Site Recovery Manager Server host machine, when you run the Site Recovery Manager.
   3. Select the Change the default database to check box and select the Site Recovery Manager database.
   4. 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	Enter a name for this data source, for example SRM.
   Description	Enter a description of the data source, for example SRM.
   TNS Service Name	Enter the address of the database server in the format database_server_address:1521/database_name.
   User ID	Enter 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.