Chapter 13 User Databases
ODBC Database
13-56
User Guide for Cisco Secure ACS for Windows Server
78-16592-01
ACS to authenticate against an ODBC-compliant relational database does not
affect the configuration of the relational database. To manage your relational
database, refer to your relational database documentation.
Note As with all other external databases supported by Cisco Secure ACS, the
ODBC-compliant relational database is not supplied as part of Cisco Secure ACS.
For general guidance with setting up your ODBC external user database, see
Preparing to Authenticate Users with an ODBC-Compliant Relational Database,
page 13-59.
The Windows ODBC feature enables you to create a data source name (DSN),
which specifies the database and other important parameters necessary for
communicating with the database. Among the parameters you provide are the
username and password required for the ODBC driver to gain access to your
ODBC-compliant relational database.
This section contains the following topics:
•What is Supported with ODBC User Databases, page 13-57
•Cisco Secure ACS Authentication Process with an ODBC External User
Database, page 13-58
•Preparing to Authenticate Users with an ODBC-Compliant Relational
Database, page 13-59
•Implementation of Stored Procedures for ODBC Authentication, page 13-60
•Microsoft SQL Server and Case-Sensitive Passwords, page 13-61
•Sample Routine for Generating a PAP Authentication SQL Procedure,
page 13-62
•Sample Routine for Generating an SQL CHAP Authentication Procedure,
page 13-63
•Sample Routine for Generating an EAP-TLS Authentication Procedure,
page 13-64
•PAP Authentication Procedure Input, page 13-64
•PAP Procedure Output, page 13-65
•CHAP/MS-CHAP/ARAP Authentication Procedure Input, page 13-66
•CHAP/MS-CHAP/ARAP Procedure Output, page 13-66