Chat now with support
Chat with Support

LiteSpeed for SQL Server 8.9.7 - User Guide

About Backing Up/Restoring with LiteSpeed LiteSpeed User Interface Configure LiteSpeed for First Use Cloud Back Up Databases Automate Maintenance Tasks Restore Databases Restore Objects View Activity and History Use Command-Line Interface Use Extended Stored Procedures Troubleshoot LiteSpeed Review Additional Resources

Register Repositories

When you create or upgrade a central repository, you must register it in the LiteSpeed UI Console before you can view its activity statistics.

Note: If the LiteSpeed install includes a central repository and the console, then LiteSpeed defaults the console to use that central repository automatically without the need to manually register and select it in the LiteSpeed console.

To register a repository

  1. Click Repository Registration from the Application Menu.

    Alternately you can click beside the Central Repository field at the bottom of the LiteSpeed UI Console and select Select Repository.

  2. Click Add repository and complete the Register New Repository dialog fields.

    Server name: Enter the name of the server instance, or click to select from a list of available server instances.

    Display name:

    Enter the name to display in the navigation pane tree.

    Connect using: Select the following options:

    Windows authentication

    Select this option to connect to the SQL Server instance using Windows authentication.

    SQL Server Authentication

    Select this option to connect to the SQL Server instance using SQL Server authentication. Complete the Login name and Password fields.

    Additional Connection Parameters

    Enter additional connection string parameters.

    TIP: Use this selection as needed to include custom parameters such as encryption, AlwaysOn and others to the SQL server connection string.

    Repository database:

    Displays the name of the repository database selected.

    Repository version:

    Displays the version of the repository.

  3. Click Test connection.

TIPS:

  • Select add repository, edit connection, delete connection, test connection, import, and export by clicking the corresponding button in the Edit Repository Registration dialog. Imports can be done from .csv files and from LiteSpeed 4.x.
  • You can click the Display name, Authentication, Login, or Password fields in the grid to change their value.

 

Related Topics

Select a Central Repository

The LiteSpeed UI Console displays the activity statistics in the Backup Manager Overview tab for the selected central repository. You can register multiple central repositories in the LiteSpeed UI Console, but you can only view activity for one at a time.

To select a central repository

Select Tools | Options and select the repository on the General tab.

Tip: You can also click beside the Central Repository field in the status bar of the LiteSpeed UI Console and select the repository from the list.

 

Related Topics

Register and Group Server Instances

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"

 

Register Servers

You must register server instances before you can manage them in the LiteSpeed UI Console. You can also register server instances that do not have LiteSpeed installed on them and perform native backups and restores through the LiteSpeed UI Console.

NOTE: You need to register all SQL Server instances involved in log shipping in the LiteSpeed UI Console to retrieve log shipping data for them.

Scenario

There are several server instances configured to report to a central repository and you need to register some of them in your LiteSpeed UI Console. ClosedClick here to see additional information for this scenario.

To register server instances

TIP: From the Edit SQL Server Registration window you can add server, edit connection, display overview tab, test connection, import and export. You can also edit credential information for each instance including display name, server name, authentication, login, password, and parent group. You can also see information for each instance including license, license type, and license expire date.

  1. Select Home | SQL Server Registration | Manage.
  2. Click Add server to add an individual server or Import to import server instances from a CSV file or the LiteSpeed central repository or a previous LiteSpeed version.

    NOTE: You can import instances from a central repository, if the central repository is configured and selected for use.

  3. (If you selected to import servers from a CSV file) Review the following for additional information:

    The first line of a valid CSV file contains the following column headers:

    • DisplayName—Specify how you want to display servers in the navigation pane tree.
    • ServerName—Computer name or IP address following by port number: <IP_address>, <port_number>.
    • Authentication—Windows or SQL Server.
    • LoginName—User name that is used for the SQL Server connection. It can be a Windows login in the following format: 'Domain\Username', or SQL Server login.
    • Password—Encrypted password for the login. May be blank.
    • LicenseInfo—License key information.
    • LicenseType—Examples: Trial, Permanent, Term.
    • LicenseEdition—Style of license. Example: Enterprise.
    • Path—Server group location of the instance.
    • ExpireDate—Date that the LiteSpeed license expires.

    Next lines contain server parameters, separated by semicolons (;), a separate line for a server. You can omit the LoginName and Password parameters to complete them later in the LiteSpeed UI Console.

    Example:

    DisplayName;ServerName;Authentication;LoginName;Password;LicenseInfo
    LicenseType;LicenseEdition;Path;ExpireDate
    W2K3-14;W2K3-14;Windows;DOMAIN\Username;3w663k3E
    spb9884_sql_auth;spb9884;SQL Server;sa;321

    NOTE: If you export server instances to a CSV file, it will contain SQL logins and obfuscated passwords. You need to manually edit the CSV file to remove the connection information before you import instances from this file.

  4. Complete the fields as necessary. Review the following for additional information:

    SQL Server Specify server name or IP address using the following format: <IP_address>, <port_number>.

    Connect using

    Select either Windows authentication or SQL Server authentication (enter the user name and password).

    NOTE: Microsoft recommends using Windows authentication when possible because it is more secure than SQL Server authentication.

    Additional Connection Parameters

    Enter additional connection string parameters.

    Tip: Use this selection as needed to include custom parameters such as encryption, AlwaysOn and others to the SQL server connection string.

    Advanced>>Display Name

    Enter the name to display in the navigation pane tree.

    Tips:

    • You can click the Display name, Authentication, Login, or Password fields in the grid to change their value.
    • Click Display Overview Tab to see the Overview tab of the LiteSpeed UI Console window for the selected instance. This will let you stay on the registration dialog and continue editing or registering new server instances, but still see overview information of the various instances.
  5. (Optional) In the Server tree, click and drag server instances to move them between groups.

    NOTE: You can group server instances in the navigation pane tree based on their category or server group. Categories are similar to server groups, but they offer different features. For more information, see Change Server Instance Grouping Methods.

Tip: In the Server tree, you can see registered SQL Server Instance nodes sorted alphabetically. To use a custom sort order, select View | Sort Instances | Custom.

Scenario

There are several server instances configured to report to a central repository and you want a new colleague to manage some of them in their LiteSpeed UI Console. Define which server instances are eligible for import.

By default, LiteSpeed allows all of the instances to be imported into other clients when you select to import from a central repository, unless you specifically exclude instances.

To exclude a server instance from import

  1. Right-click a server in the Server tree in the navigation pane and select Edit | SQL Server Registration.
  2. Clear the Allow import of this instance... checkbox and click OK.

 

Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating