• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

Is it possible to import users from an Access Databse into Active Directory in Win Serv 2k3?

We have ordered a server for about 20 computers for the press dpt in a school (Probably about 50 users will use these computers). We created a Microsoft Access Database with everyone's name, login name, temporary password, group they will be in, etc. so we can be organized, and also to be able to send out letters to everyone with their login information with mail merge...We were just going to type all of the users again into active directory when we get the server in, but is there any way to import the users from a database? Also, a little off topic, but we have set up an image that we are going to send to the other computers using ghost, and I've heard from somebody that the computer cannot be on the domain when you image it...Is that true? We just set the computer name to xxxxx and we were just going to go in and change it on each computer as it is imaged...Would there be any problem with this? Even if we just imaged 1-at-a-time and changed it there?

Thank you, Adam
1 Solution
you can use tools like dsadd, dsmod or ldifde to manipulate the ad by script.
imaging has the problem of duplicate sid's.
a computer is not identified on his name, his SID (Security ID) is used for this.
this SID is generated while the computer is installed.
you must use a sidchanger before you use a imaged pc on your net. you will find them on google.
Hi Adam,

There isn't a direct method for importing info to AD from Access. You could export the information to a .csv file and then use one of the command line tolls to import the file to AD, such as Ldifde http://support.microsoft.com/kb/237677 

With Ghost you shouldn't really ghost a machine while it's on the domain as it clones the SID and will cause problems if you have two identical SID on the same network. You can use the ghostwalker utility with ghost (ghstwalk) to change the sid, then add the machines to the domain.


Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now