Server Installation

Required Components

• Database
• ASP .NET 2 - 3.5
• Microsoft Internet Information Services (IIS)
• External IP/URL
• Access to the machine with administrative privilege.

Installation Process

• Access the machine via RDP
• Copy all installation files to the Remote Host, this should include ePOD_WebApp, a SQL Folder and a PDA Folder and any required installation files (wkhtmltopdf, xferapp, sqlexpress)

SQL Server Configuration

• Install SQL Express - with Tools if required
• Setup to use the default instance and default users
• Enable TCP/IP
• Enable PipedNames
• Add firewall exceptions to the programs and ports (1433)

Database Setup

• On the selected database.
• Create User - epod / eP0D1234.
• Open the SQL script within the SQL folder copied to the remote host.
• Check the two file paths at the top of this file match the directories for the install (only appliable to SQL Server installations).
• Run the SQL script within the SQL folder copied to the remote host.
• Grant the user created Owner rights to the database.
• Create the default site (either through a meta-data DQL script or manually)
• Create a default user of ADM for this site

ASP .NET

• Copy all of the ePOD_WebApp folder to the desired hosting directory
• Install .NET 3.5 framework, the system will work fine on .Net 2
• Check this has registered with IIS
• Open command prompt
• Navigate to the frameworks folder (C:\Windows\Microsoft.NET\Framework)
• Select your versions folder
• Run regiis -i
• Create a new application pool called ePOD and select the relevant framework
• Select advanced settings on the application pool and set up the applications pool identify, this should default to ApplicationPoolIdentify, which is fine
• Create the new .Net application, pointing to the ePOD_Webapp Folder, using the above application pool
• Bind to a external IP/URL (depends on routing)
• Apply ASP user permissions (IIS_USRS) to all files in the directory
• Allow anonymous access
• Add Default document as login.aspx

ePOD_WebApp

Once all the above is completed

• Log on to the site using the external connection (if a GDI+ error occurs there are permission issues, so revisit the above steps)
• Set up the following data:
  • Site Configuration to Client
  • Job Groups Configuration to Client
  • Vehicle (ADM)
  • Users and User Access
  • Reason Code

• If not previously specified set the vehicle checks on the site to the following:

<VEHICLE_CHECK FREQ="1">
 <QUESTION ID="0001">
   <TEXT>Please check the following items.</TEXT>
   <FORMAT>X</FORMAT>
   <SKIPABLE>N</SKIPABLE>
   <ITEMS>
     <ITEM>Oil Level</ITEM>
     <ITEM>Tyres</ITEM>
     <ITEM>Brakes</ITEM>
     <ITEM>Water</ITEM>
     <ITEM>Lights</ITEM>
   </ITEMS>
 </QUESTION>
 <QUESTION ID="0002">
   <TEXT>Please enter any comments.</TEXT>
   <FORMAT>T</FORMAT>
   <SKIPABLE>Y</SKIPABLE>
 </QUESTION>
 <QUESTION ID="0003">
   <TEXT>What is the current Mileage?</TEXT>
   <FORMAT>N</FORMAT>
   <SKIPABLE>N</SKIPABLE>
 </QUESTION>
</VEHICLE_CHECK>

Miscellaneous

• Ensure Microsoft Excel is installed - only for legacy versions
• Set up Mail Server Configuration within the Web.config file
• Set up scheduled service for auto export - only if required
• Insert any client details into the support document that are required (Site, User, Password)