Topic: Installing on Windows 2008 Server

I was installing tracmor onto a fresh Windows 2008 box and found the installation instructions to be incomplete and the required resources to be unclear.  The following are all of the steps I took to install tracmor including setting up the database on a different drive, installing the required IIS features and other required software.  I hope someone else finds this information helpful.

Install the following:
    .NET 4.0 - http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=22
    C++ 2008 - http://www.microsoft.com/download/en/confirmation.aspx?id=29
    mySQL    - MySQL Server only - http://dev.mysql.com/downloads/installer/
    tracmor - http://code.google.com/p/tracmor/downloads/list extract to F:\wwwroot
Install IIS
Server Manager -> Roles -> Add Role -> Web Server (IIS)
Include the following Role Services from Application Development: CGI, ISAPI Extensions, ASP.NET

Install PHP
http://windows.php.net/downloads
Install to C:/PHP/   
During setup select the option to run as server - IIS FastCGI

IIS Manager setup
Select Sites -> Add Web site (under Actions)
    Site name:  tracmor
    Physical Path:  F:\wwwroot
Select Handler Mappings from tracmor Home -> Add Managed Handler (under Actions)
    Requested path - *.php
    Executable - C:\php\php5nsapi.dll
    Name: PHP
   

Edit Configuration files
Set the following value in C:\ProgramData\MySQL\MySQL Server 5.5\ my.ini
    datadir = "F:\SQLdata\"
    Restart mySQL service
Fill the following values in F:\wwwroot\includes\configuration.in.php
    Fill SQL login information to DB_CONNECTION_1  user = {tracmor user}, password ={password}
    change _DOCROOT_ value to F:\wwwroot
Edit F:\wwwroot\data_model\create.sql
    change all 'TYPE =' to 'ENGINE =' and 'TYPE=' to 'ENGINE ='

MySQL Database Initialization
Run MySQL Command Line Client and execute the following commands:
    CREATE DATABASE tracmor;
    CREATE USER '{tracmor user}'@'localhost' identified by '{password}’;
    GRANT ALL ON tracmor.* to '{tracmor user}'@'localhost';
    USE tracmor
    SOURCE F:/wwwroot/data_model/create.sql
    SOURCE F:/wwwroot/data_model/data.sql