IntelliTrack Check In/Out - Manual (Page 50)

I NTELLI T RACK C HECK I N -O UT V 8.1
User Manual
20
Microsoft SQL
Server IntelliTrack uses Microsoft SQL Server to run the workstation application
database and Microsoft SQL Server Compact Edition to run the batch
application database.
Microsoft SQL Server is a server application that runs the IntelliTrack
DMS Check In-Out database. The Microsoft SQL Server Express is also a
server application that runs the IntelliTrack Check In-Out database. If you
are not using SQL Server, the system will install and use SQL Express
to run the IntelliTrack Check In-Out database. SQL Server or SQL Express
must be properly setup and configured before the SQL Server and the SQL
CE database will communicate (please refer to
“RDA Configuration” on
page 20 for more information). (Microsoft SQL Server Compact Edition is
the database engine used on the handheld device to run the IntelliTrack
Check In-Out CE database. It is installed on the handheld device during
CE Batch Portable installation. The information that is stored in the local
SQL Server CE database table is transferred to the main IntelliTrack work-
station application database during a “data upload” and then integrated into
the main database after it is processed.)
RDA
Configuration Important: The sections that follow deal with advanced network settings.
Consult your system administrator to determine the best Remote Data
Access (RDA) setup option for your system.
The required components for Remote Data Access (RDA) can be installed
on your system in various configurations: installing all components on a
single computer, distributing the components between two computers, or
distributing the components on three or more computers. Another compo-
nent to RDA is permissions. In a domain setting, active directory permis-
sions must be allowed for PCs in the network domain that receive data
from the DMS Batch application. Please note that in a workgroup setting,
active directory is not used (local permissions are used).
RDA Setup Categories
IntelliTrack contains two RDA setup categories:
1. Automatic IIS Setup: allows for automatic IIS-IntelliTrack CE con-
figuration when you run the Create IIS Dependencies Utility. This util-
ity is run during IntelliTrack software installation when you opt to
automatically configure IIS. The utility is also accessible from the
DMS Program menu: Start > Programs > IntelliTrack > DMS Appli-
cation > Create IIS Dependencies Utility.
2283.book Page 20 Thursday, July 7, 2011 2:29 PM