[Webinar] Learn how to a build a cloud-first strategyRegister Now


I want to be able to automatically create Windows Server 2003 domain users via a live link to an access database

Posted on 2004-11-05
Medium Priority
Last Modified: 2010-04-19
A slightly quirky one this.

I am putting in a 2003 network in a small school. In paralell to this project a student database is currently being created in Access (though not by me.)

I am no good with databases, so please forgive any ignorance in my question.

What we want to know if it is possible for fields in the database (ie. first name, last name, class etc.) to automatically create logons in Active Directory ? These would need to be linked live to the database (ODBC ?) so that if, for example, a student left, their logon would be removed / disabled. Also, group membership would need to be changed to reflect the relevant year and therefore, the approriate login script.

I personally can't see this ever working, but maybe that is the cynic in me. The database people seem to think it can be done.

Any suggestions ?
Question by:benleicester
  • 2

Accepted Solution

map000 earned 750 total points
ID: 12506265
I don't know if you can do this, but for sure you can export the database and format it in a csv format and than use a tool to import the user in active direcotry
ldifde it's an exemple of importing program
LVL 11

Expert Comment

ID: 12506446
you can only use the database for quering with tools.
if one student is deleted in your db, you must trigger a script, that will modify accounts in AD or in your local groups, depending if you have a domain or only a standalone server.
for ad use tools like dsget, dsquery, dsmod to edit the objects.
for a standalone server you can use "net localgroup" or "net user"

Author Comment

ID: 12522640
Sorry WeHe intended to split the points but not sure how to do it.
LVL 11

Expert Comment

ID: 12528587

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I guess it is not common knowledge to most Wintel engineers/administrators: If you have an SNMP-based monitoring system in your environment (and it's common to have SNMP or Syslog) it's reasonably easy to enable monitoring of the Windows Event logs,…
Numerous times I have been asked this questions that what is it that makes my machine log on so slow, there have been cases where computers took 23 minute exactly after taking password and getting to the desktop. Interesting thing was the fact th…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Screencast - Getting to Know the Pipeline

868 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question