Hey Mike, I haven't used Active Directory in quite some time but I created an intranet webapp once that used Active Directory for universal login credentials so that the users can use their same windows login as the login for the webap. I was able to query the Active directory to get the users login but did not store it in the database although it could have easily been done. I guess there are really 2 main operations here. 1. Get the users AD info. 2.Sync up AD with the datbase after you store their info. For the first party you can just query aginst the Active Directory to get what you need. Just use the canonical name to search for the correct data. The second part of this could be handled by stored procedures. If you use stored procedures to CreateUser, UpdateUser, DeleteUser. Then you can call those stored procedures when you are updaing the user in the Active directory that way you'll be able to sync up the info in the db and ad. -Eddie
Shane Heasley <[EMAIL PROTECTED]> wrote: Mike: Did you get an answer to this question? I was out of town for a week. It is possible to pull the logged in user's AD info (in a Windows environtment) using cgi.Auth_User (or something very similar - I'm doing this from memory). However, that is only if you have authentication set in IIS so this approach will not work for a public site. What exactly are you trying to accomplish? There might be a different route to the same results. Cheers, Shane On Oct 12, 11:36 am, Mike Gillespie wrote: > Is there a way to get user account data/attributes from active > directory into a table in a SQL server and while keeping AD as the > authoritative source keep the data synchronized in the SQL server > table? Is there some kind of data transformation utility that can be > used? > > Would need new users added to AD to be inserted into the table and any > attributes that are changed to be updated in the table. This can be a > scheduled task or preferrably a rea-time synchronization. > > If this is possible, can someone point me to some documentation? I'm > an Oracle and mySql guy not a SQL server one.. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [EMAIL PROTECTED] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
