Drupal 7 + IIS + MSSQL + Windows Authenticaiton

Installing Drupal 7 on Microsoft Windows 2008 with IIS 7 and MSSQL 2008 is not very easy.  It is even more difficult to set it up using Windows integrated authentication and URL rewrite (for Clean URL's).  I recently suffered through this process and documented it to spare others the same fate.

Key features of this setup:

1. Windows integrated authentication used for Drupal MSSQL database connectivity and serving Drupal web content.
2. URL rewrite rules to enabled Clean URLs in Drupal.
3. Special patch to enable MSSQL integrated Windows authentication during Drupal installation wizard.

If you have a choice, stick with Drupal on a LAMP stack.

HTH,

VVK