Internal Hosting - Installation Instructions

Installing PoolCar on an Internal Server

1. Download Installation Files

Download the installation packages from the Lingo Systems server.
The download links will be provided by Lingo Systems.

You will receive:

• IIS application files (ZIP file)

• SQL database backup

2. Create and Restore the Database

1. On your SQL Server (2005 or 2008), create a new database

   • Recommended naming format: PoolCarXYZ (where XYZ is your organisation name)

2. If setting up separate Test and Production environments, repeat this step for each

3. Restore the downloaded SQL backup over the new database

   • Ensure Overwrite existing database is ticked

3. Create the IIS Website

1. On the web server, create a new website in IIS

2. (Optional) Assign the site its own Application Pool

3. Ensure the server supports ASP.NET Framework v3.5

4. Deploy the Application Files

1. In the directory linked to your IIS website

2. Extract the IIS ZIP file you downloaded

5. Configure the Database Connection

1. Open the web.config file

2. Update the database connection string to point to your SQL Server

3. If using Integrated Authentication, ensure the IIS process account
   (usually Network Services) has access to the SQL database

6. Configure Email (SMTP)

1. In web.config, scroll to the bottom

2. Update the SMTP server settings

   • Default is localhost

   • Change this to your mail server

3. Ensure your mail server allows SMTP relay from the IIS server

7. Confirm Login Method

Check with the project sponsor how users will log in. Supported options include:

• IIS Integrated Authentication

• Active Directory groups

• Forms login with users managed in PoolCar

8. Configure the Website URL

1. Assign a domain name or URL for staff access

   • Example: http://poolcar

2. Configure this in IIS using Host Headers

3. Some organisations may use a generic host name with a port number instead

9. Confirm Database Backups

Ensure the PoolCar database is included in your nightly backup process.

10. Set Folder Permissions

On the web server, grant Modify permissions to the IIS process account
(e.g. Network Services) for the following folders:

• (approot)\TempFiles

• (approot)\UploadedFiles

11. Test the installation

1. Open the website using the URL staff will use

2. You should see:

   1. The Login page, or

   2. The Welcome page

3. If an error screen appears, the most common issue is an incorrect SQL connection string

Need Help?

If you cannot find an answer here, log a support request via the Smartrak Service Desk.