Problems in using external database with ACS

[bburn78]

Hi

I have configured the external database, SQL Server 2000 to connect successfully with ACS. However, ACS still cannot authenticate me successfully. I am totally lost here. I will really appreciate some help here

Some of my other problems:

1. How do I write stored procedures in my database to communicate with ACS?

Error messages: 1. No users matching, although my table is certainly not empty

Thanks for the help in advance,

Your sincerely,

bburn

[m.singer]

Thought these links might be useful.

http://www.cisco.com/en/US/partner/products/sw/secursw/ps2086/products_user_guide_chapter09186a008007e6a6.html#xtocid28990103

http://www.cisco.com/en/US/partner/products/sw/secursw/ps2086/products_user_guide_chapter09186a008007e34c.html

[bburn78]

Hi

Thank you for replying. I tried the sample routine to create a procedure given in the sample documentation. However, it doesn't seem to work. Here's my stored procedure. What's wrong with it?Use Test

GO

if exists (select * from sysobjects where id = object_id('dbo.CSNTAuthUserPap') and sysstat & 0xf = 4)

drop procedure dbo.CSNTAuthUserPap

GO

CREATE PROCEDURE CSNTAuthUserPap

@username varchar(64), @pass varchar(255)

AS

SET NOCOUNT ON

IF EXISTS( SELECT memberID

FROM Member

WHERE memberID = @username

AND password = @pass )

SELECT 0,csntgroup,csntacctinfo,"No Error"

FROM Member

WHERE memberID = @username

ELSE

SELECT 3,0,"odbc","ODBC Authen Error"

GO

GR

ANT EXECUTE ON dbo.CSNTAuthUserPap TO ciscosecure

GO

It keeps on throwing invalid column names. Any solutions?

Thank you.