My background is predominantly Linux-based servers, with which I can configure anything however I want. However, I'm building a Drupal6 site for a client, who (despite my warnings) wishes to self-host from a server in his offices -- and is running Windows Server 2008R2 (likely upgrading to Small Business Server 2011 at some point).
While I have a good idea of the technology stack I'd use in Linux, I'm much less sure how I'd go about this in a Windows-based server environment.
What is the ideal technology stack for serving web-based PHP applications (specifically Drupal) in Windows?
And no, I can't reformat the thing as a Linux box. :) Thanks!
EDIT: One thing worth noting is that I've used MAMP (Apache2, MySQL) in Mac OS 10.6 as my testing environment. It'd be great if the tech stack could use MySQL as I'd ideally like to just dump then import the tables I've been using.