IntelliTrack Stockroom Inventory - Manual (Page 223)

Chapter 12
CE Batch Setup
195
Warning: This RDA setup option does not work with MSDE. You must use
SQL Server or SQL Express with this RDA setup option.
Option 2 Considerations
1. Works in a domain environment only.
2. Works with SQL Server only.
Security Requirements: Option 2
When you use Remote Data Access Setup: Option 2, please be aware of
the following security requirements.
1. The installer must have administrative privileges on the PC.
2. You may only use SQL Server Authentication with SQL Server.
3. A domain user account is required.
4. Since IIS and SQL Server reside on different computers, the Create IIS
Dependencies Utility cannot be used to configure IIS and SQL Server
permissions; they must be manually configured. Please refer to
“Manu-
ally Configuring IIS in Windows XP Operating Systems” on page 199 or
“Manually Configuring IIS in Windows Vista Operating Systems” on
page 200
for more information.
5. Set the Sync URL setting in the Batch Synchronization Utility to: http:/
/{IIS Computer name}/{virtual directory name}/sqlcesa35.dll. For
more information about the Sync URL setting in the Batch Synchroni-
zation Utility, please refer to
“Sync URL Setting” on page 210 .
Local Computer Contains:
--IntelliTrack Workstation
Application
-- Microsoft ActiveSync or Windows
--IIS
Remote Computer Contains:
-- SQL Server
Mobile Device Center for Vista software
2289.book Page 195 Thursday, July 9, 2009 2:35 PM