If you Windows Sharepoint Services with the internal SQL database, then you only need pay for the hardware, Windows server licence, and Windows CALs (such as per-user CALs for staff, and Windows external connector for parents), plus the cost of SLG and annual maintenace.
For MOSS2007 Server
MOSS 2007 Server license
MOSS 2007 For internet sites license
MOSS 2007 CALs for Staff users
Windows Server CALs for Staff users
Windows External Connector (covers non employees - students, parents)
For the Sims server
SQL per proc license (or express)
Windows Server CALs for Staff Users (if bought per user above then this will cover all internal servers accessed from outside)
Windows External Connector
Internal servers are covered by the multiplexing licensing requirements, so if users are authenticated and access a *Windows* server even through sharepoint (or anything else) then you will still need the relevant CALs and external connector licenses.
We want to use the exchange integration too so only need some per user CALs for it as only staff will have access.
For our site (150 staff, 1100 students) it's around £9k for MS licenses alone.
The break even point between just getting Sharepoint CALs for all users (staff, students (parents free when students are licensed) and the For Internet sites licenses is around the 400 student or so level.
David, pardon my ignorance but will this allow me to use reports to provide information only on the child of the parent who is logged in? The information I'm going to get out of SIMS is for all students, so what are you linking the student SIMS IDs with? Can you give a bit more information about what you're doing with AD?
we currently have integration between sims.net and active directory. I have put in place a script that checks all students against AD, if the student doesn't have an account it will create them one.
We are currently packaging up our scripts, so we can release them with a howto on integrating SIMS.net and moodle.
2 servers for SharePoint one SQL and one Web, for either MOSS 2007 or WSS 3 would be a minimum recommendation where you are expecting significant usage. Often customers also consider using ISA server to publish SharePoint over the internet for more flexibility and added security.
When choosing a solution I would also factor in the support requirements of SharePoint against having SharePoint and SLG hosted for you.
All the best, Jeremy