Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.8 - Installation Guide

Software Requirements

Before beginning installation, review this section to ensure your system meets the following minimum hardware and software requirements.

Requirements Details

Operating
System

Microsoft Windows Server 2008 32-bit and 64-bit (x64) (All Service Packs)

Microsoft Windows Server 2008 R2 64-bit (x64) (All Service Packs)

Microsoft Windows Server Core 2008 R2

Microsoft Windows Server 2012 64-bit (x64) (All Service Packs)

Microsoft Windows Server Core 2012

Microsoft Windows Server 2012 R2 64-bit (x64) (All Service Packs)

Microsoft Windows Server Core 2012 R2

Microsoft Windows Server 2016 64-bit (x64) (All Service Packs)

Microsoft Windows Server Core 2016

Microsoft Windows Server 2019 64-bit (x64) (All Service Packs)

Microsoft Windows XP 32-bit and 64-bit (x64) (All Service Packs)

Microsoft Windows Vista 32-bit and 64-bit (x64) (All Service Packs)

Microsoft Windows 7 32-bit and 64-bit (x64) (All Service Packs)

Microsoft Windows 8 32-bit and 64-bit (x64) (All Service Packs)

Microsoft Windows 8.1 32-bit and 64-bit (x64) (All Service Packs)

Microsoft Windows 10 32-bit and 64-bit (x64) (All Service Packs)

Database
Software

SQL Server 2005 32-bit and 64-bit (x64) (All Service Packs)

SQL Server 2008 32-bit and 64-bit (x64) (All Service Packs)

SQL Server 2008 R2 32-bit and 64-bit (x64) (All Service Packs)

SQL Server 2012 32-bit and 64-bit (x64) (All Service Packs)

SQL Server 2014 32-bit and 64-bit (x64) (All Service Packs)

SQL Server 2016 64-bit (x64) (All Service Packs)

SQL Server 2017 64-bit (x64) (All Service Packs) when hosted on a Windows operating system.

Additional
Software

.Net Framework 4.5 installed before you install the LiteSpeed UI Console and LiteSpeed Core Cloud Components.

.Net Framework 3.5 required with SQL Server 2005, 2008 and 2008R2.

If using IBM Spectrum Protect (Tivoli Storage Manager - TSM), the TSM API and Backup/Archive Client version 5.3 or later should be installed.

Microsoft Internet Explorer 6.0 or later.

Adobe Reader 8 or later to view PDF guides.

Supported Cluster Environments

  • Windows Server 2008 Failover Cluster
  • Windows Server 2008 R2 Failover Cluster
  • Windows Server 2012 Failover Cluster
  • Windows Server 2012 R2 Failover Cluster
  • Windows Server 2016 Failover Cluster
  • Windows Server 2017 Failover Cluster
  • Windows Server 2019 Failover Cluster
  • HP PolyServe Matrix Sever 3.6.1
  • Veritas Storage Foundation HA for Windows 5.0

Supported Storage Appliances

LiteSpeed has been tested and is certified to work with Dell DR4100 and DR4000 Storage Appliances.

VMWare and Hyper-V Environments

LiteSpeed has been tested and is certified to work under VMware and Hyper-V environments.

Hardware Requirements

Requirements Details
Processor Follow the recommendations for the SQL Server version used.
Disk Space

250 MB of disk space for installation

NOTE: The disk space required may vary based on options selected during installation.

Memory

Follow the recommendations for the SQL Server version used.

NOTE: The memory required may vary based on the following:

  • Applications that are running on your system
  • Size and complexity of the database
  • Amount of database activity
  • Number of concurrent users accessing the database
Monitor SVGA with a minimum resolution of 1024x768

 

Related Topic

Privilege and Grant Requirements

Review Privilege and Grant Requirements

LiteSpeed requires the following privileges and grants:

Account Requirement

User account that performs the LiteSpeed installation

 Windows administrator rights and DBA privileges required to
  • Install stored procedures and extended stored procedures
  • Create databases, tables, and indexes
  • Insert, update, and delete to/from the MSDB, LiteSpeedLocal and LiteSpeedCentral databases
User account that runs the LiteSpeed UI Console

Power User privileges (or some equivalent).

NOTE: When executing a Double Click Restore, Windows Vista, Windows Server 2008, and higher require that the Windows user account is an administrator.

SQL Server service account

Sysadmin server role privileges required to

  • Push stats to local repository
  • Back up or restore using extended stored procedures
  • Execute a scheduled job
  • Start a job manually

TIP: The SQL service account needs at least read\write access to the following directory and all its contents:
C:\ProgramData\Quest Software\LiteSpeed\SQL Server\

NOTE: SQL Server Configuration Manager should always be used when changing SQL Server service accounts.

SQL Agent service account (or a proxy account)

Windows or SQL Server accounts specified during instance configuration (Start | All Programs | Quest Software | LiteSpeed for SQL Server | Instance Configuration)

For more information, see Configure Server Instances.

If you select SQL Server authentication, the SQL Server account must have sysadmin server role privileges, while the Activity Manager service account must have the Log on as a service permission.

If you select the Windows authentication method for both the local and central repository, then the Activity Manager service account specified on the Service Account page must have the sysadmin privileges and the Log on as a service permission.

NOTE: If the central repository is located on another server, the LiteSpeed Activity Manager service account must have domain rights for two-way communication between the local and central repositories.

Windows or SQL Server account (Application Button | Repository Registration...)

For more information, see About Collecting Statistics in Repositories.

Db_owner of the central repository (required to retrieve data from the central repository)

Windows or SQL Server account (Application Button | SQL Server Registration...)

Sysadmin server role privileges required to

  • Connect to SQL Server and retrieve SQL Server properties
  • Back up or restore
  • Execute procedures, retrieve MSDB history
  • Access repositories

TSM with LiteSpeed

If using TSM, its recommended that the following line be added to the dsm.opt file used by LiteSpeed.

errorlogname "C:\ProgramData\Quest Software\LiteSpeed\SQL Server\Logs\dsierror.log"

 

Install and Upgrade scenarios

Install LiteSpeed

  1. Install LiteSpeed Locally.
  2. Configure Server Instances.
  3. Install LiteSpeed on Remote Server Instances.
  4. Register Central Repositories.
  5. Register Server Instances.

For information about configuring LiteSpeed for the first use, please refer to the User Guide.

Upgrade LiteSpeed

  1. Make sure you have a license key for the new version of LiteSpeed for SQL Server.

    For more information, see License Registration. about licensing LiteSpeed.

  2. Disable LiteSpeed jobs.

    Before installing a new version of LiteSpeed, disable any LiteSpeed jobs that are scheduled to run at the time of upgrade on all servers where you plan to upgrade LiteSpeed.

    To disable jobs on a server instance

    1. Select a SQL Server instance in the Job Manager window.
    2. CTRL+Click to select multiple LiteSpeed jobs.
    3. Right-click anywhere in the selected area and select Disable Jobs.

    NOTE: Instead of disabling LiteSpeed jobs, you can open SQL Server Configuration Manager, right-click SQL Server Agent and select Stop. Be aware that no other SQL Server Agent jobs will be able to run. SQL Server Agent jobs control backups, database maintenance, and other third-party application jobs. Review the full list of jobs and their upcoming schedules to make sure no other products will be affected during the upgrade.

  3. Upgrade LiteSpeed UI Console.

    To upgrade the LiteSpeed UI Console, run the LiteSpeed installation. Install LiteSpeed Locally

  4. Upgrade LiteSpeed on SQL Server instances.

    To upgrade LiteSpeed... Complete the following steps...

    Locally
    1. Install LiteSpeed Locally.
    2. Configure Server Instances.

    Remotely
    1. Install LiteSpeed on Remote Server Instances.

    NOTE: You must have the Complete installation on the machine from which you wish to run the remote deploy.

    On a cluster

    Run local or remote cluster installation. For more information, see Cluster Installation.

  5. Enable LiteSpeed jobs.

    After you upgraded LiteSpeed on all instances, enable jobs that were disabled before the upgrade.

    To enable jobs on a server instance

    1. Select a SQL Server instance in the Job Manager window.
    2. CTRL+Click to select multiple LiteSpeed jobs.
    3. Right-click anywhere in the selected area and select Enable Jobs.

    NOTE: If you stopped SQL Server Agent instead of disabling the jobs, right-click SQL Server Agent and select Start.

Uninstall LiteSpeed

To uninstall, reinstall or change LiteSpeed, right-click LiteSpeed for SQL Server from the Add or Remove Programs option in the Control Panel and select an option.

TIPS:

  • If you select Change and then Remove, you can delete LiteSpeed Local repositories during the uninstall.
  • LiteSpeed Central repository and Repository Cleanup job for the central repository are not part of the uninstall. They will remain after the uninstall has completed.

 

Installation

To begin a local server installation of LiteSpeed, copy the appropriate LiteSpeed .msi file to the server on which you will install.

To install LiteSpeed on... Use this installer...
32-bit Windows LiteSpeed.msi
64-bit Windows LiteSpeed-x64.msi

You may run the installer from a network device, but for performance and stability reasons Quest Software recommends that the installer be run locally.

To install LiteSpeed using the Installation wizard

  1. Double-click .msi to start the installation.
  2. Use the following information to help guide you through the installation wizard:
    Screen Description
    User Information Enter your user information. You will need to decide whether this application should be added to the Windows Start menu for all users or only for the installation owner. Quest Software recommends the default installation, for all users.
    Destination Folder

    Select the install location. You may select any directory that meets the following criteria:

    • The destination cannot be shared.
    • The path must exist on all nodes.

    The default install location is: C:\Program Files\Quest Software\LiteSpeed\SQL Server.

    Installation Type

    Select Complete to install all features or Custom to install only selected features. If you select Custom, the components you may install are:

    • LiteSpeed Help
    • LiteSpeed UI Console
    • LiteSpeed Core—Installs LiteSpeed for SQL Server on each SQL Server instance on which you plan to use LiteSpeed.
    License Information

    Select one of the following options:

    • Run LiteSpeed in Trial Mode or Restore Only Mode

    • Register your copy of LiteSpeed

      Enter your license key obtained from Quest Software. Ensure that the key does not contain any line breaks or trailing spaces.

    NOTE: If you upgrade from a LiteSpeed 8.5 or earlier installation then you will be required to enter a site message. If you upgrade from LiteSpeed 5.x or earlier you will be required to provide a new license key. For more information, see License Registration.

After the LiteSpeed program files are installed, the LiteSpeed Instance Configuration wizard will help you complete the installation of LiteSpeed components into your SQL Server environment. For more information, see Configure Server Instances.

  

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating