Author Topic: bulk change passwords server 2003  (Read 10764 times)

0 Members and 1 Guest are viewing this topic.

Offline Gerard

  • Moderator
  • Board Veteran
  • *****
  • Posts: 3006
  • Gender: Male
bulk change passwords server 2003
« on: December 04, 2006, 02:58:57 PM »
is there anyway to bulk reset passwords on Windows server 2003



iv tried highlighting the folder of users and selecting multiple users and teh reset password option isnt avaibable



cheers

Offline dfinney

  • Technicians
  • Board Veteran
  • *****
  • Posts: 1906
  • Gender: Male
    • Wallace high school
Re: bulk change passwords server 2003
« Reply #1 on: September 25, 2007, 11:43:32 AM »
gerard dont know if you sorted this problem or not but though i would post this anyway for anyone else with this problem.

First export the user names you need from AD into a text file then import into excel.Then add net user then the username them the password it should look like this.

net user username password.

You need to make sure that there is only one space between each word or it will not work you can do this by using the replace function in the edit menu.

save the text file then rename the file extenstion to .bat, then double click on the bat file and ta da password reset.

I also have a mass user creation formula in excel if anyone is interested all you have to do is add your user info to the first couple of colums and change the syntax of the ou's to suite your own ou's and it should work.

Can't take credit for this script as i know dam all about excel formula it was richard form the board who made it for me.

« Last Edit: September 28, 2007, 12:52:25 PM by forthill »
"Education is a progressive discovery of our own ignorance."

Offline Kev

  • Valued Contributor
  • ****
  • Posts: 550
  • Gender: Male
Re: bulk change passwords server 2003
« Reply #2 on: September 25, 2007, 03:09:33 PM »
Just out of interest, How do u guys go about creating bulk accounts on 2003 server?
There seems to be several methods and I'm not sure which is the most straight forward.
Time flies like an arrow. Fruit flies like a banana.

Offline dfinney

  • Technicians
  • Board Veteran
  • *****
  • Posts: 1906
  • Gender: Male
    • Wallace high school
Re: bulk change passwords server 2003
« Reply #3 on: September 27, 2007, 03:47:24 PM »
kev the technician from my board made me a excel file for this it uses the DSADD USER & DSMOD USER command for .bat files then all you have to do is run it on the 2003 server.

Its acutally a very clever way to do it.

First off you create 7 columns. user id, first name, surname, intake year, full name, create user command and mod user, the clever bit is he used MATCH formula for the last two columns which automatically adds the info from the first five columns.

So basically what you type into the first  5 columns gets duplicated and added to the corresponeing field.

As far as i can remember the formula is something like this "&A2&".

ill have a look for the excel file and post it on here
« Last Edit: September 27, 2007, 04:16:27 PM by forthill »
"Education is a progressive discovery of our own ignorance."

Offline Kev

  • Valued Contributor
  • ****
  • Posts: 550
  • Gender: Male
Re: bulk change passwords server 2003
« Reply #4 on: September 28, 2007, 10:36:38 AM »
Thanks Forthill. Thats very handy. I just put together a basic CSV file using Excel and then imported its contents
using the CSVDE command.
Works fine, but doesnt allow you to create passwords for the new users. So i have to run a 2nd routine to
remedy this.
Time flies like an arrow. Fruit flies like a banana.

Offline dfinney

  • Technicians
  • Board Veteran
  • *****
  • Posts: 1906
  • Gender: Male
    • Wallace high school
Re: bulk change passwords server 2003
« Reply #5 on: September 28, 2007, 01:00:37 PM »
yea i tried using the CSVDE command myself but kept running it problem with some users not being created etc.
So the technician from my board came up with that excel file.

its going to come in handy over the next couple of months as i am changing all my username, i am getting C2k to complie me a list of all my users, just means the pupils only have to remember there passwords instead of two usernames and two passwords.
"Education is a progressive discovery of our own ignorance."

Offline casper

  • Administrator
  • Board Veteran
  • *****
  • Posts: 5405
  • Gender: Male
    • http://www.niaviation.co.uk
Re: bulk change passwords server 2003
« Reply #6 on: September 28, 2007, 03:03:47 PM »
You can get a list of all your users from the web provisioning website.
Northern Ireland Aviation Forum and Gallery
Aviation Photos
I don't think you're stupid, I think what you do is stupid.

Offline dfinney

  • Technicians
  • Board Veteran
  • *****
  • Posts: 1906
  • Gender: Male
    • Wallace high school
Re: bulk change passwords server 2003
« Reply #7 on: September 28, 2007, 03:21:06 PM »
where is the web provisioning service as i know nothing about the management of c2k, i may be the ict technician but i don't have access to the management console cant quite remember the reason for this, the vibe i got was they were scared i might peek in the principals folders.

funny thing is 2 teachers have access so it takes longer to get things done as they teach all day
"Education is a progressive discovery of our own ignorance."

Offline Gerard

  • Moderator
  • Board Veteran
  • *****
  • Posts: 3006
  • Gender: Male
Re: bulk change passwords server 2003
« Reply #8 on: October 18, 2007, 03:07:06 PM »
thanks :D

richard is going to convert all of our username so that the pupils only have the 1 aswell but with 2 passwords :D

should save a lot of hassle