I'm playing with this SIMS.net thing also, will report back on any breakthroughs.
Are there any parts in particular you are stuck at?
The Moodle Docs should be fairly up to date now after my input
In the documentation Configuring SQL Server 2005
 Add a new view to MS SQL Server is mentioned twice, is this an oversight? I have it in my head moodle doesn't talk directly to the SIMS.Net database and that you create an intermediary or have I dreamt this??? Told you, I've been out the loop on the tech side of things for years now.
Secondly, is FreeTDS 0.64 only required when using Linux??
And thirdly, is the link between moodle and the sims.net databde (or the intermediary database dynamic or does it need to be scheduled?
You do need to add a view to the SQL - the connection from moodle is direct to the SQL database, it is read only so the SQL is safe.
FreeTDS is Linux only - I'm not sure what you need to do a windows connection
The link is live so nothing needs to be schedules unless you want to do autocreation of user accounts.
How do you test FreeTDS is doing its job? I have followed the steps in the docs and have a table for the timetable with the periods I set, but it is blank.
Also, does the account for Enrolements have to be the 'sa' account or can it be a system managers account?
Have tried that - doesn't work with Ubuntu
I've followed the instructions and created the templates and setup the external database for the enrolments but alas I can't see any courses. What I can't figure out is where the view created by pasting in the query is referenced. I've actually "run" the view in SQL studio manager and it works but it looks to me like it uses UPN number to indentify students. Therefore would I be right in thinking that we need UPN's in AD too?
Just to ask again... Does anyone know if it has to be the 'sa' account or can it be an account of a system manager in SIMS?
You shouldn't really be using UPNs to identify pupils to other systems. You should really be using the admission number. The UPN's purpose is purely tracking of pupils’ movement and progress within the maintained school system in England, not as a general purpose identifier.
From the guidance notes on UPNs at http://www.teachernet.gov.uk/_doc/11...ate%202007.rtf
• the UPN to be as far as possible a ‘blind number’, held by schools on the pupil's electronic record, and only output when required to provide information to the LA, to the Department or other central agencies (e.g. QCA/NAA), or to another school to which the pupil is transferring. The UPN should not be regarded as an automatic adjunct to the pupil's name, routinely appearing on any record or document relating to them;
• schools should not enter UPNs on pupils' paper files or on any other physical documents, including admission and attendance registers, and should continue to use the admission number, not the UPN, as a general pupil reference number within the school.
Ok, now I gotsa find out the 'sa' password - hmmmm
Found the password, set it - and still get a blank timetable.