Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2002-12-10 : 09:09:45
|
| Our web-based course takes the FORM entered username / password and validates them using a SQL 2000 stored procedure against table Users in the course database.This is OK, until a customer wants to validate the username and password against a private database of their own using LAPD. The customer database is maintained and has a current list of employees all the time. This will avoid having to regularly update new employees in the course database.Once authenticated, I'll need to retrieve the user name, email and department then insert a row in my users's table to track course completion.I'd like this have minimal impact the existing implementation. Maybe the Login stored procedure could be extended to handle all this handshaking, that would be great. I've seen articles on ASP code to do LDAP authentication, maybe that's the way to go? ASP not SQL?I'd appreciate any pointers to articles or feedback from anyone that has implemented something similar to this requirement.Thanks,Sam |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-12-10 : 09:24:27
|
| When I did LDAP authentication before it was through ASP. There was a reasonable third party component about that made the process less painful.-------Moo. |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2002-12-10 : 12:40:15
|
| Any ideas on the 3rd party package ??Anyone else care to speculate on whether it could be done in SQL?Help !Sam |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-12-11 : 03:54:36
|
quote:
Any ideas on the 3rd party package ??
We tried a few, to varying degrees of success. The one that worked best was the IP*Works LDAP component. (I think that you get a whole set of components in one package, if you're lucky your web provider will have it.)-------Moo. |
|
|
|
|
|
|
LDAP