IntelliTrack Stockroom Inventory - Manual (Page 222)

I NTELLI T RACK S TOCKROOM V 7.0
User Manual
194
3. Works with SQL Server, SQL Express, and MSDE.
Security Procedures: Option 1
When you use Remote Data Access Setup: Option 1, please be aware of
the following security requirements:
1. The installer must have administrative privileges on the computer.
2. This setup option may use SQL Server or NT Authentication with
MSDE, SQL Express, or SQL Server.
3. This setup option does not require a Domain user account.
4. Since IIS and SQL Server reside on the same computer, the Create IIS
Dependencies Utility (Start > Programs > IntelliTrack > DMS >
DMS Application > Create IIS Dependencies) may be used to con-
figure IIS and SQL Server permissions with this setup option. When
you run the IIS Utility, it will:
Create the virtual directory (erases existing virtual directory before cre-
ating the new one).
Set full control file permissions for the Internet user in the virtual direc-
tory.
Add the Internet user to the DMS_USER role in SQL Server. (This
does not apply to MSDE.)
Verify the Sync URL setting in the Batch Synchronization Utility. It
should be set to http://{computer name}/IntelliTrack/
sqlcesa35.dll. For more information about the Sync URL setting
in the Batch Synchronization Utility, please refer to
“Sync URL Setting”
on page 210 .
RDA Setup:
Option 2 This option uses two computers: the IntelliTrack workstation application,
IIS and ActiveSync or Windows Mobile Device Center software resides on
the local computer; SQL Server resides on a remote computer.
2289.book Page 194 Thursday, July 9, 2009 2:35 PM