11-53
User Guide for Cisco Secure ACS for Windows Server
78-14696-01, Version 3.1
Chapter 11 Working with 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 PAP 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 11-45
.
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 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 11-46
.
Note
If you enabled CHAP/MS-CHAP/ARAP authentication, the CHAP
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.