Chapter 11 Working with User Databases
ODBC Database
11-50
User Guide for Cisco Secure ACS for Windows Server
78-14696-01, Version 3.1
A return code of 4 or higher results in an authentication error event. These errors
do not increment per-user failed attempt counters. Additionally, error codes are
returned to the AAA client so it can distinguish between errors and failures and,
if configured to do so, fall back to a backup AAA server.
Successful or failed authentications are not logged; general Cisco Secure ACS
logging mechanisms apply. In the event of an error (CSNTresult equal to or less
than 4), the contents of the CSNTerrorString are written to the Windows Event
Log under the Application Log.
Configuring a System Data Source Name for an ODBC External
User Database
On the Cisco Secure ACS server, you must create a system DSN for
Cisco Secure ACS to communicate with the relational database.
To create a system DSN for use with an ODBC external user database, follow
these steps:
Step 1
In Windows Control Panel, double-click the ODBC Data Sources icon.
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.
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 database runs.
Step 7
Click OK.
Result: The name you assigned to the DSN appears in the System Data Sources
list.
