Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

Authenticating to ACS 3.1 using ODBC connection

I have setup a table in a SQL Server 2000 database with user names and passwords for testing purposes and when trying to run the stored procedure creation script for CHAP (per the ACS user guide instructions), I get a lot of errors. They are:

Error:

Server: Msg 170, Level 15, State 1, Line 2

Line 2: Incorrect syntax near '`'.

Server: Msg 207, Level 16, State 3, Procedure CSNTExtractUserClearTextPw, Line 8

Invalid column name 'csntgroup'.

Server: Msg 207, Level 16, State 1, Procedure CSNTExtractUserClearTextPw, Line 8

Invalid column name 'csntacctinfo'.

Server: Msg 207, Level 16, State 1, Procedure CSNTExtractUserClearTextPw, Line 8

Invalid column name 'No Error'.

Server: Msg 207, Level 16, State 1, Procedure CSNTExtractUserClearTextPw, Line 8

Invalid column name 'csntpassword'.

Server: Msg 207, Level 16, State 1, Procedure CSNTExtractUserClearTextPw, Line 12

Invalid column name 'odbc'.

Server: Msg 207, Level 16, State 1, Procedure CSNTExtractUserClearTextPw, Line 12

Invalid column name 'ODBC Authen Error'.

Server: Msg 208, Level 16, State 11, Line 1

Invalid object name 'dbo.CSNTExtractUserClearTextPw'.

Anyone using this method and if so, what did you use to create the stored procedure?

1 REPLY
New Member

Re: Authenticating to ACS 3.1 using ODBC connection

I was finally able to get this working with PAP. Not sure what the problem was with CHAP.

151
Views
0
Helpful
1
Replies
CreatePlease to create content