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?
