13-73
User Guide for Cisco Secure ACS for Windows Server
78-16592-01
Chapter 13 User Databases
ODBC Database
Step 11 From the DSN Procedure Type list, select the type of output your relational
database provides. Different databases return different output:
•Returns Recordset—The database returns a raw record set in response to an
ODBC query. Microsoft SQL Server responds in this manner.
•Returns Parameters—The database returns a set of named parameters in
response to an ODBC query. Oracle databases respond in this manner.
Step 12 To support ASCII, PAP, or PEAP(EAP-GTC) authentication with the ODBC
database, follow these steps:
a. Select the Support PAP authentication check box.
b. In the PAP SQL Procedure box, type the name of the PAP SQL procedure
routine that runs on the ODBC server. The default value in this box is
CSNTAuthUserPap. If you named the PAP SQL procedure something else,
change this entry to match the name given to the PAP SQL procedure. For
more information and an example routine, see Sample Routine for Generating
a PAP Authentication SQL Procedure, page 13-62.
Note If you enabled PAP authentication, the PAP authentication SQL
procedure must exist on the ODBC database and must have the exact
name specified in the PAP SQL Procedure box. If it does not, be sure
to create it in the ODBC database before attempting to authenticate
users against the ODBC database.
Step 13 To support CHAP, MS-CHAP, ARAP, EAP-MD5, or LEAP authentication with
the ODBC database, follow these steps:
a. Select the Support CHAP/MS-CHAP/ARAP Authentication check box.
b. In the CHAP SQL Procedure box, type the name of the CHAP SQL procedure
routine on the ODBC server. The default value in this box is
CSNTExtractUserClearTextPw. If you named the CHAP SQL procedure
something else, change this entry to match the name given to the CHAP SQL
procedure. For more information and an example routine, see Sample Routine
for Generating an SQL CHAP Authentication Procedure, page 13-63.