Automating a password change to a user account daily

Synopsis:  I am hosting a webserver at my company which allows our clients to gain access to a downloads and helpdesk ticketing section.  Once the client authenticates via a username and password they are allowed to gain access to the restricted members site.  My company has a sales demo server which hosts our product and allows a client/potential client to demo new features through a Citrix Web environment.  The user account and password of the day to gain access to the demo box would be posted in a section that only clients can see. We have an account on the the box that is to be used by all clients; however the password needs to be changed daily.  I have an Excel spreadsheet that contains 400 random passwords that I gave to our webmaster.  He knows how to have the password pull from the spreadsheet each day, but my question is how can I synchronise the password to mach whatever the new password being posted is and have the NT password change fully automated?  Thank you very much for your help.  Please let me know if I need to be clearer.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ok, this isn't necessarily the cleanest way to do it, but here's a thought.

First off, see this site for a command line way to change your password:

What you could do is create a batch script (or if you know VBscript, that might be better) to automate changing the password.  You could export your Excel file to a text file with your 400 entries.  Then just have a daily scheduled task to run your new batch file, which would set the password by grabbing the next entry in your password list.  I'd have to sit down for a while to figure out the cleanest way to do this...  But I don't see why it wouldn't work.

What you could do is find a utility that could take the 1st password in the list, remove the line, then append the line to the file (moving it to the end of the password list).  When I say "take" the password, it actually sets it as a variable.  Then you use that command line password change with this variable to set the password.  If you wanted, you could then create a file with just this one password, which could then be read by your website to display to users.

There's probably a lot cleaner way to do this, but I think if you worked through this, step by step, you could do it pretty easily.  Just make sure your scheduled task runs as a user that is capable of changing this remote user account's password!


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
csjacksonAuthor Commented:
That is what I came up with, however the problem that I am having is the syntax to get the script to pull the password from a specific date.  The other issue is that the net user command asks you to verify the password 2x.  I think if I can answer those questions I will be good.  Thanks!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Networking

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.