Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I work at a university maintaining the computer science department server. I am looking for a more economical way to stream line the set up of student accounts. CS students are granted a Username and password an IIS virtual directory, FTP virtual directory, and a mysql database. Server is running windows server 2003R2 (Possibly migrating to 2008R2)

The server is running a domain though no students physically log a terminal into it (No computers are part of my domain.) Creating the account is a manual process. I did right a PHP script to query the Universities AD and copy the information and write it to my AD.

I then have to create basically the users home directory. I tried having AD do it but since the user never physically logs in it never creates the directory. Permissions on this folder are set to User - full, Instructors (group) - full, Users (group) - read, IUSER - read. Inside of the users folder their is a "Private" folder with permissions User - full, instructors (group) - full.

Next step is IIS I create a virtual directory in the default web site pointed to the users home directory so they have a website.

Same goes for FTP virtual directory in the default ftp configuration to allow the users to upload files to their website.

Mysql I have to create a user and password then create a mysql scheme (database) full access for the user and full access to the instructors account to be able to access the students database.

All of this is done manually and takes me a week to do. The closest description is maybe a shared hosting environment. Is there a better way to do this? Scripting wise, or better structure setup?

share|improve this question

2 Answers 2

up vote 0 down vote accepted

Is there any particular reason why you need to create the home directory? The profile isn't setup because it's not used for anything. If you need a shared folder, you can do it with a single shared folder rather than setting up the entire profile.

For the IIS scripting check out c:\inetpub\adminscript\adsutil.vbs. That's a good command line tool for scripting things like this.

Mysql also has a command line tool which can automate the creation of the accounts and permissions.

share|improve this answer
    
When I say home directory it is basically just a folder that the student puts their files in. For example my directory structure on the server is C:\students\{User Name} Then I point the IIS virtual directories to that folder so the student gets their website and ftp to upload the files. –  Barracksbuilder Jun 23 '11 at 17:11
    
Got ya. That makes good sense. Not sure why 'home directory' made me think of the user profile directory. Your configuration sound good, so for the command line, you can use md to create the folder, and then cacls or icacls for the permissions. –  Scott Forsyth - MVP Jun 23 '11 at 19:03
    
Thanks, I just wanted to make sure my structure was good. –  Barracksbuilder Jun 27 '11 at 4:31

If you want to setup something like Shared Hosting enviroment, take a Look aht HMC http://www.microsoft.com/downloads/en/details.aspx?FamilyId=C9CBBC69-4AE4-450D-AF5E-F49E7C701CF4&displaylang=en Microsoft Solution for Hosted Messaging and Collaboration. But you will need to setup a lot of stuff.

Another option is the make VBS scripts to automate the process.

share|improve this answer
    
Not sure I follow with the HMC it looks more like for exchange, sharepoint and communicator. We would not be using any of those products. I am using IIS (web and ftp) AD for user accounts, and a mysql database. I am going to investigate VBS I was looking into doing it with PHP as I am a PHP programmer. –  Barracksbuilder Jun 28 '11 at 19:35

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.