Questions? We’ve got answers!

New Installation and Setup Procedure


Initial Installation and Setup *

Install Microsoft SQL Express 2012 or later *


Download SQL Express 2014 or later from official Microsoft website. We recommend including the Management tools.

Use a 64 bit version if your computer is 64 bit

Google Microsoft SQL Express 2014. Be sure to choose the official Microsoft website for your download.

Create a new instance of the database.

View a YouTube video of these steps by clicking here

Name the instance Tractivity (default is SQLExpress and you can name whatever you prefer)

Be sure to choose Mixed Mode Authentication

Set the sa password to Tr@c1234 or another password of your choice, be sure you write this down. You will use this password again when setting up the iTrac web service

Enable services to automatic

Complete the installation

Configure SQL *

1.Run SQL Server Configuration Manager.
2.Go to SQL Server Network Configuration > Protocols for YOUR_INSTANCE_NAME.
3.Make sure TCP/IP and VIA is enabled.
4.Right-click on TCP/IP and select Properties.
5.Verify that, under IP2, the IP Address is set to the computer’s IP address on the local subnet.
6.Scroll down to IPAll.
7.Make sure that TCP Dynamic Ports is blank.
8.Make sure that TCP Port is set to 1433.

Open Firewall 1433,1434,7373 TCP and 1434 UDP *

View a YouTube video of these steps by clicking here

The server firewall needs to allow ports 1433,1434 for access to the SQL Express database

The server firewall must also allow port 7373 to support iTrac data capture cell phone and tablet devices.

Forward port 7373 on router *

Determine the server local IP address:

  1. On your serve run the cmd prompt
  2. Type ipconfig ENTER
  3. Look for IPv4 Address. . . . . . . .:

This is the local server IP address that the router will forward to

Log into the Internet router and set up port forwarding for port 7373 from all addresses.

The actual process steps for setting up a port forwarding on your router will vary from router to router. You may need to consult with your router documentation for information on how to configure a port forwarding

Set up DNS Service *

You may want to create an external DNS to allow intranet and internet traffic the ability to reach the server using the same web address.

We recommend using a DNS service such as (available as a free service) for this purpose. The DNS service will use an address such as to resolve to your ISP IP address. If you have a dynamic IP address, you can download a program named DUC from the site and run it on your server to keep your address updated every 5 seconds.

If iTrac devices will only be used within the wireless network (never used outside the building) then the DNS service is not required and you may use the service local IP address as the web address.

Install iTrac Webservice *


You will need your login and password to gain access to this file


Configure iTrac webservice *

The database path needs to be set in the application settings.

Open the application settings feature

Add a new setting

Name: DataSource Value: ServerName\TRACTIVITY

Add a new setting

Name: UserID Value: sa

Add a new setting

Name: Password Value: Tr@c1234 (or whatever your password was set to)

Add a new setting

Name: Catalog Value: Timeport

Add a new setting

Name: dbType Value: SQL

Save and close


Test the IIS installation *

This “test” can only be completed after employees have been added to the database.

You will need to install TracManager on server (if not already done)

Download the TracManager installation file from the Tractivity support website.

You will need to use the login and password credentials you received with your license certificate. Save the installation file to a shared location that can be accessed from other computers on the network.

View a YouTube video of these steps by clicking here

Be sure the application pool is running and the web site is running. If not, start them.

Click on the iTracWeb site

Click the Browse *:7373 Action

Click on Login and try a user name and password.

If EmpID is not zero – success.

Be sure the router is forwarding port 7373 to the computer

For trouble-shooting help click here