I have a Win 2003 as a webserver. Not the best hardware. Currently I'm running IIS6 with .Net support, but i'm not using it. I'm running plain html. I'm getting around 1,000 hits a day (on the front page). Mostly from the local intranet, but the machine still gets hits from outside.
I am considering the introduction of dynamic content on my index page and other pages, for that, I need to chose the database, language, and webserver.
The easiest solution is to use Access/ASP-ASP.Net/IIS6, but I doubt that Access can handle that load, unless someone out there has tried it.
I'd really like to use the IIS server installed, because it saves setting up a complex system that no one knows how to replicate except me, which I want to avoid.
Would MySQL work with ASP? That would be cool. If not, PHP maybe.
Finally, MSSQL, which is not free, and I have no idea of the cost.
This is an open discussion, I'll be giving 100 points for the best five answers.