Im currently designing a website for my old school, and its my first paid project. But I believe that I have hit my first obstacle: Authenticating Users.
The school network, has just upgraded from Novell, to Windows 2003 Server. There are just over 1000 profiles (usernames and Passwords etc)
The school have requested that for the Website, that there should be a private intranet for the pupils to access one large directory, and to access the directory they must provide their current username and password from the Windows 2003 Server, Active Directory I believe?
The problem is, is that the Schools website is hosted with a 3rd Party company, and not by the school themselves, and obviously, the Windows 2003 Server is located at the school.
I wondered if there was any way, of making a live connection, for authentification to the schools 2003 server? and if successful create a session cookie to access the private area? Perhaps to collect the information on intervals of every 5 hours, and dump all of the user id's into a MySQL database?
Im really not sure if this is possible? I just wondered if anyone has been having the same issue, or if any one knows a solution to this problem.
I will be willing to send the resolver, a £50 cheque for any fixes to this issue.
P.S. Something else they have requested, is that after this has been accomplished, the the students should then be able to accecss their own indidual profiles, from the 2003 Server? via the 3rd Party web server?
I may have an alternative solution for you. I am not exactly sure if this is the route you want to take. However, consider Caspio Bridge it is an online bases software to create webforms and database applications without programming. Caspio Bridge has feature such as unlimited user authentication, recorld level security, file uploads and downloads and much more and again you can create these without having to programm. With Caspio Bridge you can easily import or export data in CSV or MS Access.