JPEGGER INSTALLATION INSTRUCTIONS

JPEGGER INSTALLATION INSTRUCTIONS

Installing Microsoft SQL Server 2005 And All JPEGger Versions

These instructions are for installations where SQL Server and JPEGger will reside on the same server AND the software installation media will be downloaded.

Installing Microsoft SQL Server

  • Create the following folders:C:Transact, C:TransactCD1, C:TransactCD2 and C:TransactSP3.
  • Download from EOpen (https://eopen.microsoft.com) SQL Server 2005 CD1 and CD2 from the installation media/website and save them into C:Transact.Once downloaded you will have to execute them (to uncompress); uncompress them into subdirectories CD1 and CD2, respectively.
  • Download SP3 (or the latest Microsoft SQL Server 2005 service pack) and uncompress into folder SP3 (or whatever the latest SP).
  • Download JPEGger complete install. Note that you will select custom setup and select the option for SQL Server installation (if available).
  • After downloading, browse to C:program filesjpegger, and double click the INSTALLSQL.bat file to install SQL Server.This is a lengthy process and takes approximately 20 minutes to complete.
  • Note that if you wish to use a different SQL instance name or change the default SQL Data directory, change the SQLOptions.ini file BEFORE executing the batch file.Please see Microsoft documentation before making any changes.
  • If you are installing from DVD, you may also edit INSTALLSQL.bat to use the DVD instead.
  • After installing SQL Server 2005, open the Services manager and stop the service SQL Server (MSSQLSERVER).Execute the latest Service Pack for Microsoft SQL Server 2005.A reboot may be required, but typically by stopping the service in this step you will not have to restart.
  • Restart services SQL Server (MSSQLSERVER) and SQL Server Agent (MSSQLSERVER).
  • Open Microsoft SQL Server Management Studio.(Start>All Programs>Microsoft SQL Server>SQL Server Management Studio)
  • Connect to local machine when prompted using Windows Authentication.
  • In SQL Studio, File>Open, and browse to C:Program FilesJpegger and select the CreateJPeggerDB query file.After selecting that file, select execute at the top of the screen which will create the JPEGger database.
  • Note that the script will change some default settings that we recommend changing for most environments. These may be changed based on a specific environment.
  • StartAll ProgramsJPEGgerInstall JPEGger Service for SQL server.
  • Create a System

    • Related Articles

    • SQL SERVER 2008 INSTALLATION

      Attached you will find print screens of a typical SQL Server 2008 Installation with all the features to run EZCash and/or JPEGger.

    • Duplicate signature pad images in jpegger multiviewer

      The signature pad cameras should be set up as 'single file' with no file name specified. If a signature pad camera is incorrectly setup as 'directory' then it will produce duplicate signature images in jpegger.

    • Setting up Cameras/Devices in JPEGger

      After logging into JPEGger click on the "CAMERAS" button. Click on "New" Fill out "Camera Name", "Device Name", and "Camera Type". -Choose the yard location from the dropdown menu. Even if the yard only has one location, or it will not show in Scrap ...

    • SQL SERVER MAINTENANCE PLAN INSTRUCTIONS

      Attached you will find print screens illustrating how to create maintenance plans in SQL Server 2005 AND SQL Server 2008.

    • No held images - Jpegger doesn't save 1st image for Scrap Dragon Classic

      There are some newer versions of the Jpegger service that do not save the 1st image to disk for use by Scrap Dragon Classic in the view held list. A version of the service that will save the 1st image to disk is attached. 1. Download and unzip the ...