INSTALLING MICROSOFT SQL SERVER 2008

INSTALLING MICROSOFT SQL SERVER 2008

Attached you will find SQL2008Install.bat and SQL2008Install.ini which contain the minimum options necessary for JPEGger and/or EZCash to run correctly. More options may be added at your discretion. Before installation, customization for the system’s configuration is most likely necessary for both files.

  1. Edit SQL2008Install.bat
    • Change the location of the installation media:

      D:Setup.exe /ConfigurationFile=”C:Program FilesJPEGgerSQL2008Install.INI”

      The “D:” should be the location that the Microsoft SQL Server 2008 installation software resides.In this example, the DVD Rom drive containing the installation software is D: drive.However, this could be a different drive or even a shared drive with an extended path.

    • Change the location of the installation configuration:

      “C:Program FilesJPEGgerSQL2008Install.INI”

      This points to the other file mention in this article.In this example, I chose to put both the batch file and configuration file in the JPEGger application folder.

      Note:On 64-bit servers, JPEGger installs in “C:Program Files (x86)” folder.Therefore, change the location to:

      “C:Program Files (x86)JPEGgerSQL2008Install.INI”

  2. Edit SQL2008.INI

    At the top of the configuration file, there is a section that will need to be changed based on the server’s configuration.Section is as follows:

    ;*****************************************************************************;
    ; Specifies the path to the installation media folder where setup.exe is located.

    MEDIASOURCE=”D:”

    ; Specify the installation directory.

    INSTANCEDIR=”C:Program FilesMicrosoft SQL Server”
    ;INSTANCEDIR=”C:Program Files (x86)Microsoft SQL Server”

    ; Specify the root installation directory for native shared components.

    INSTALLSHAREDDIR=”C:Program FilesJPEGgerMicrosoft SQL Server”
    ;INSTALLSHAREDDIR=”C:Program Files (x86)JPEGgerMicrosoft SQL Server”

    ; Specify the Instance ID for the SQL Server features you have specified. SQL Server directory structure, registry structure, and service names will reflect the instance ID of the SQL Server instance.

    INSTANCEID=”MSSQLSERVER”
    ;*****************************************************************************;

    • The first line is for the source of the installation media.Change:

      MEDIASOURCE=”D:”

      to the location of the media.

    • The second group of lines define the installation location of the Instance software.This may be done anywhere on the server.This example shows the default installation paths for both the 32-bit and 64-bit locations.

      INSTANCEDIR=”C:Program FilesMicrosoft SQL Server”

      ;INSTANCEDIR=”C:Program Files (x86)Microsoft SQL Server”

Note:The line not in use has a “;” as the first character which comments that line out so that it will be ignored by installation

    • Related Articles

    • SERVER MIGRATION/UPGRADE

      A. General This document describes the best practices for moving Scrap Dragon Classic, Scrap Dragon Xtreme, JPEGger and EZCash to a new server. The goal is to move all of the software programs, configurations and data from the old server to the new ...
    • RECOMMENDED BACKUP STRATEGY FOR SQL SERVER

      The purpose of creating SQL Server backups is to minimize the loss of data in a damaged database. In accordance with the Microsoft recommendations (MS191239 SQL.90), we recommend the following: All databases should be setup using the Full Recovery ...
    • 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.
    • "cannot locate the Microsoft Visual FoxPro support library"

      Error when opening Scrap Dragon Classic. There are just 2 DLL files in the MS VFP support library. One or both is missing from the \Dragon folder on the server. This is usually caused by an anti-virus or anti-malware utility which quarantines the ...
    • 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.