New Installation and Setup Procedure

Initial Installation and Setup *

Install Microsoft SQL Express 2012 or later *

Download SQL Express 2012 or later from official Microsoft website. We recommend including the Management tools however, this is optional.

Suggested link: https://www.microsoft.com/en-us/download/details.aspx?id=50003

Of Google Microsoft SQL Express 2012. 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

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.

Enable services

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. . . . . . . .: 192.168.xxx.xxx

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 no-ip.org (available as a free service) for this purpose. The DNS service will use an address such as mycompany.hopto.org to resolve to your ISP IP address. If you have a dynamic IP address, you can download a program named DUC from the no-ip.org 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 IIS *

View a YouTube video of these steps to install on Windows Server 2012 by clicking here

Windows 7, 8.1, 10 –

Turn on Windows Features before attempting to install the iTrac web service,

setup 1

Configure IIS *

Download http://support.tractivity.com/download/iTracWF.exe

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

View a YouTube video of these steps by clicking here

Install iTracWF.exe

Accept all defaults.

Type Inetmgr into the run box then press enter.

Then open the tree on the left and expand. Click on iTracWeb.

setup 2

Create an application in the Application Pools. This example name is iTrac

IIS1A

Click on the Add Application Pool Action, then enter the name of the application pool. Set the .NET Framework to v2.0.50727 as shown

IIS2

Click OK to close the form

Click on the new application name and then click the Advanced Setting Action

setup 3

If a 64-bit computer, you need to set the Enable 32-Bit Applications setting to True

Configure iTrac webservice *

setup 4setup 5

 

setup 7

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

 

setup 10setup 11

 

setup 12

setup 13

setup 14

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

setup 16

Click the Browse *:7373 Action

setup 17

setup 18

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

 

 

  *