If you already have a data source configured for your standby database, skip this section and continue with “Configuring and starting the DirectConnect server”.
When you installed Microsoft SQL Server, an ODBC driver was also installed. Configure this driver to connect to the standby database.
To configure the Microsoft SQL Server ODBC driver
Open the ODBC Driver Manager by navigating to Control Panel | Administrative Tools and double-clicking the Data Sources (ODBC) icon.
Click on the Drivers tab, and verify that the Microsoft SQL Server driver, which is named SQL Server, is version 2000.86.1830.00 or later. If it is an earlier version, go to the Microsoft Web site to download and install the correct version.
Click on the System DSN tab, click Add, select the Microsoft SQL Server driver. Click Finish.
Due to permissions, you may have to set up the ODBC
data source as a user data source under the User DSN tab.
In the Name field, enter a name that identifies your standby Microsoft SQL Server, for example, my_standby_mssql_datasource. Use this name later, when you configure the ECDA access service.
In the Server drop-down list, select the standby Microsoft SQL Server database, and click Next.
Be sure that “with SQL Server authentication using a login ID & password entered by the user” is selected, and the “Connect to Microsoft SQL Server to obtain default settings” check box is checked. Enter a valid Microsoft SQL Server Login ID and Password, and click Next.
Check the “Change the default database to” check box, select the standby database from the drop-down list, and click Next.
Click Finish.
Verify ODBC connectivity to the standby database by clicking Test Data Source. If connectivity is not successful, verify that you have configured the ODBC driver with the correct login name, database password, and permissions.
Click OK.
You should now see your Microsoft SQL Server data source in the list of System Data Sources. Click OK.
