Mike, do you actually need the AD data duplicated in MSSQL, or is it enough to be able to query & join the AD data when needed? That would remove the synchronization needs, you would only be storing the minimum amount of data in SQL tables and joining AD info when needed. As Eddie pointed out you can encapsulate a lot into stored procedures, but I think it would be even less maintenance if you just leave the data in AD.
Here is general info on connecting an MSSQL server to AD http://articles.techrepublic.com.com/5100-6345_11-5259887.html and info on doing it such that you can query from CF to MSSQL to AD http://blog.tech-cats.com/2007/09/querying-active-directory-through-sql.html I found even more examples by searching for "sql server join active directory" on Google. Let us know how it works out, -CPC -- ------------------------ Houston ColdFusion Users Group www.houcfug.org [EMAIL PROTECTED] On 10/22/07, Mike Gillespie <[EMAIL PROTECTED]> wrote: > > > Was hoping for an easier way out of the box... > > On Oct 21, 10:59 pm, Eddie Pequeno <[EMAIL PROTECTED]> wrote: > > 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.. > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
