Chapter 9 Working with Logging and Reports
Working with ODBC Logs
9-20
User Guide for Cisco Secure ACS for Windows Server
78-14696-01, Version 3.1
Configuring a System Data Source Name for ODBC Logging
On the computer running Cisco Secure ACS, 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 communicating
with the relational database is created on the computer running
Cisco Secure ACS. The name you assigned to the DSN appears in the Data Source
list on each ODBC log configuration page.
Configuring an ODBC Log
The logs to which this procedure applies are as follows:
•
Accounting
•
Administration
•
RADIUS Accounting
