Cisco Systems 3.3 Configuring a System Data Source Name for RDBMS Synchronization

9-37

User Guide for Cisco Secure ACS for Windows Server

78-16592-01

Chapter 9 System Configuration: Advanced

RDBMS Synchronization

net start CSDBSync

and then press Enter.

The Microsoft ODBC CSV driver can now access the accountActions CSV file

properly.

Configuring a System Data Source Name for RDBMS

On the Cisco Secure ACS, a system DSN must exist for Cisco Secure ACS to

access the accountActions table. If you plan to use the

CiscoSecure Transactions.mdb Microsoft Access database provided with

Cisco Secure ACS, you can use the CiscoSecure DBSync system DSN rather than

create one.

For more information about the CiscoSecure Transactions.mdb file, see

Preparing to Use RDBMS Synchronization, page 9-33.

To create a system DSN for use with RDBMS synchronization, follow these steps:

Step 1 From Windows Control Panel, open the ODBC Data Source Administrator

window.

Tip In Windows 2000, the ODBC Data Sources icon is located in the

Administrative Tools folder.

Step 2 In the ODBC Data Source Administrator window, click the System DSN tab.

Step 3 Click Add.

Step 4 Select the driver you need to use with your new DSN, and then click Finish.

A dialog box displays fields requiring information specific to the ODBC driver

you selected.

Step 5 In the Data Source Name box, type a descriptive name for the DSN.