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.

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.

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.

a

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.

b

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.

c

Select the Change the default database to check box and select the Site Recovery Manager database.

d

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.

The ODBC driver for your database is ready to use.