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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Problems in using external database with ACS

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

2 REPLIES
New Member

Re: Problems in using external database with ACS

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.

88
Views
0
Helpful
2
Replies
CreatePlease login to create content