Appendix b: database maintenance, Appendix c: compact workstation utility, Appendix d: manual iis setup – IntelliTrack Inventory Management User Manual

Page 14: Appendix e: checking iis setup, Appendix f: microsoft access integration

background image

I

NTELLI

T

RACK

I

NVENTORY

V

8.1

User Manual

xiv

xiv

Bin Location Table ................................................................................................... 239
Field Types ............................................................................................................... 240

APPENDIX B: Database Maintenance ...............................................243

Verifying Database Connection................................................................................ 244

IntelliTrack Database ........................................................................................ 244
SQL Server Logon Information ........................................................................ 244
Testing the Database Connection via the UDL File.......................................... 245
Connecting to the Database with SQL Server Management Studio ................. 249
Changing the Application Database Connection .............................................. 251

Database Backup and Restore .................................................................................. 256

Database Maintenance ...................................................................................... 257
Database Backup and Restore with SQL Server/SQL Express ........................ 257
IntelliTrack Backup and Restore Database Utilities ........................................ 273

APPENDIX C: Compact Workstation Utility ......................................281

Overview .................................................................................................................. 282

Compacting the Workstation Application File.................................................. 282

APPENDIX D: Manual IIS Setup .......................................................283

Overview .................................................................................................................. 284
Manual IIS RDA Setup Requirements ..................................................................... 284

Manually Configuring IIS on Windows XP/

Windows Server 2003 Operating Systems........................................................ 285
Setting up IIS v6.0 to Allow the DMS Web Service Extension........................ 286
Manually Configuring IIS in Windows Vista/Windows 7/

Windows Server 2008 Operating System ......................................................... 288
Setting Up IIS v7.0 to Allow the DMS Web Service Extension....................... 289
Configuring the IntelliTrack Application Pool ................................................. 296

APPENDIX E: Checking IIS Setup ....................................................301

Overview .................................................................................................................. 302
Reaching the Batch Synchronization Utility............................................................ 302

Sync URL Setting ............................................................................................. 303

APPENDIX F: Microsoft Access Integration ....................................307

Overview .................................................................................................................. 308

2287.book Page xiv Thursday, July 7, 2011 4:45 PM