Re: Synchronising NT User Accounts with a database.

From: Roger Seielstad (roger@wiredeuclid.COM)
Date: 08/05/02

From: "Roger Seielstad" <roger@wiredeuclid.COM>
To: "Chris Reeve" <>, <>
Date: Mon, 5 Aug 2002 07:24:45 -0400

The easiest way that I would see to do that is to roll your own code, using
ADSI, probably as part of a web app, to capture the data then sync it to the

Thomas Eck's book on ADSI Scripting for System Administration probably
covers 90% or more of the code you'd need. It's a bit short on the database
side, but that's not its focus. The code for database manipulation is
available from the MSDN site.

Roger D. Seielstad
E-mail Geek

Moi su pas tracasser

----- Original Message -----
From: "Chris Reeve" <>
To: <>
Sent: Friday, August 02, 2002 5:36 AM
Subject: Synchronising NT User Accounts with a database.

> Morning All,
> Just looking for some advice/pointers, and I was wondering if any of you
> could help?
> I need to synchronise NT user accounts with a database table (that holds
> username and full name information). By this I mean I need an admin to
> add/delete/edit NT user accounts via the PDC and then for this
> information to be applied to a database table.
> Additional points.
> - I don't mind using any third party code, although I would prefer for
> there to be some clever MS proprietary way
> - I don't mind if the admin has to do some additional task(s) but I
> would like to keep it to a minimum
> - The synchronisation is only required one way. NT > Database. There
> will be no need for this to work the other way
> Info.
> - Database is SQL Sever 2000
> - PDC and database are different machines
> Any help would be greatly appreciated.
> Feel free to post directly to me.
> Thanks in advance
> Chris
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (
> Version: 6.0.380 / Virus Database: 213 - Release Date: 24/07/2002