Drupal Install on Windows Server 2008 SP1 and IIS7

Some people have asked for some installation help,
so I looked around what I have on my Server to install the stuff and I copy it here,
to discuss and to make it better and more complete.

The listed stuff is working on the english Version of Microsoft Server 2008 (us-en).
The Server 2008 has a diffrent Version of the IIS7 then the Version you are running under VISTA or XP. Its nearly the same, but not 100%. The Server variant is more reliable and speedy. The 2 hotfixes I mention here are absolutly necessairy to support multisession cookie support.

The Server 2008 Part as XML :

---

Install these Hotfixes after installing the Services, if you do not have installed the SP2 for Server 2008 (which is not available yet):
http://support.microsoft.com/kb/954946/en-us
http://support.microsoft.com/kb/957508/en-us

---

Extract PHP 5.x to the directory c:\php

PHP per script or manual:

%windir%\system32\inetsrv\appcmd set config /section:system.webServer/fastCGI /+[fullPath='c:\php\php-cgi.exe']
%windir%\system32\inetsrv\appcmd set config /section:system.webServer/handlers /+[name='PHP_via_FastCGI',path='*.php',verb='*',modules='FastCgiModule',scriptProcessor='c:\php\php-cgi.exe',resourceType='Unspecified']
%windir%\system32\inetsrv\appcmd set config /section:defaultDocument /+files.[value='index.php']
%windir%\system32\inetsrv\appcmd set config /section:defaultDocument /-files.[value='iisstart.htm']
$text = get-content C:\php\php.ini-recommended
$temp = $text[0]
for ($i=1, $i -lt $text.length' $i++)
{
$line = $text[$i]
if("$text[i] -eq ";extension=php_mysql.dll")
{
$outtemp = $outtemp+ "extension=php_mysql.dll"
}
elseif("$text[i] -eq "extension_dir = "./")
{
$outtemp = $outtemp+ "extension_dir = "C:\php\ext"
}
elseif("$text[i] -eq ""; fastcgi.impersonate = 0;")
{
$outtemp = $outtemp+ ""; fastcgi.impersonate = 1;"
}
elseif("$text[i] -eq "; cgi.fix_pathinfo=0")
{
$outtemp = $outtemp+ "; cgi.fix_pathinfo=1"
}
else
{
$outtemp = $outtemp+ text[$i]
}
out-file -filepath 'C:\php\php.ini' -inputobject $outtemp
rename C:\inetpub\wwwroot\iisstart.htm iisstart.old

----

Integrate PHP to IIS 7 per script or manual:

cd C:\windows\system32\inetsrv\
appcmd set config /section:system.webServer/fastCGI /+[fullPath='c:\php\php-cgi.exe']
appcmd set config /section:system.webServer/handlers /+[name='PHP_via_FastCGI',path='*.php',verb='*',modules='FastCgiModule',scriptProcessor='c:\php\php-cgi.exe',resourceType='Unspecified']
appcmd set config /section:defaultDocument /+files.[value='index.php']
appcmd set config /section:defaultDocument /-files.[value='iisstart.htm']
cd \
ren C:\inetpub\wwwroot\iisstart.htm iisstart.old

----

Extract Drupal 6.x to the directory C:\inetpub\wwwroot\drupaltest entpacken
configure the directories and files per script or manual:

cd C:\inetpub\wwwroot\drupaltest
copy sites\default\default.settings.php sites\default\settings.php
icacls sites\default\settings.php /grant BUILTIN\IIS_IUSRS:(OI)(CI)(M)
icacls includes\install.inc /grant BUILTIN\IIS_IUSRS:(OI)(CI)(M)
md sites\default\files
icacls sites\default\files /grant BUILTIN\IIS_IUSRS:(OI)(CI)(M)

----

Install MySQL and do something like (or choose other names and passwords):
CREATE DATABASE DrupalTest;
GRANT ALL PRIVILEGES ON DrupalTest.* TO 'Drupal'@'%' IDENTIFIED BY 'Drupal500!';

---

Install the Modrewrite from Micosoft:

http://www.microsoft.com/downloads/details.aspx?familyid=6C15B777-8D9E-4...

Modrewrite has an import function, which allows you to import the .htacess.
After the import, you will have the full rewrite functionality in Drupal.
To import, you first have to setup a webpage for your Drupal in the IIS Manager, but I think I do not have to explain this little step here.

---

So, I hope this was a little help for those of you who want to install it a first time under Server 2008
The install under VISTA and XP is Diffrent, but nearly the same expect of the hotfixes, which are only for the Server.

Tanguero