Kenny Katzgrau has a recent post on the Code Fury blog talking about the combination of CodeIgniter, IIS, MySQL and MSSQL and how it all works in his installation (after a few small gotchas).

There are a lot of people out there who call themselves "LAMP" developers — short for Linux, Apache, MySQL, PHP. That’s the standard configuration for production PHP applications. Recently, I ended up having to build a CodeIgniter application on Windows, IIS, Mysql+MS-SQL, and PHP. Sound like there are bound to be issues? You bet, and it especially hurts because now I'm a real-live WIMP developer. And what made it even more interesting was that due to constraints, I had to develop the application in Ubuntu and deploy to Windows for production.

He includes the list of the "gotchas" that he came across when doing the installation - six of them:

• PHP and MSSQL on Ubuntu
• PHP and MSSQL on Windows
• mssql vs. sqlsrv
• File Permissions and Logging
• No .htaccess Fo' You!
• 2 Databases, 1 Application