Chapter9 Wo rking with Logging and Reports
Working with ODBC Logs
9-26
Cisco Secure ACS 3.0 for Windows 2000/NT Servers User Guide
78-13751-01, Version 3.0
Configuring a System Data Source Name for ODBC LoggingOn the Cisco Secure ACS server, you must create a system DSN for
Cisco Secure ACS to communicate with the relational database that is to store
your logging data.
To create a system DSN for use with ODBC logging, follow these steps:
Step 1 In Windows Control Panel, double-click ODBC Data Sources.
Step 2 In the ODBC Data Source Administrator page, 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.
Result: A dialog box displays fields requiring information specific to the ODBC
driver you selected.
Step 5 Type a descriptive name for the DSN in the Data Source Name box.
Step 6 Complete the other fields required by the ODBC driver you selected. These fields
may include information such as the IP address of the server on which the
ODBC-compliant relational database runs.
Step 7 Click OK.
Step 8 Close the ODBC window and Windows Control Panel.
Result: The System DSN to be used by Cisco Secure ACS for communication
with the relational database is created on your Cisco Secure ACS server. The
name you assigned to the DSN appears in the Data Source list on each ODBC log
configuration page.