LiteSpeed for SQL Server 8.8 - User Guide

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.

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

About Collecting Statistics in Repositories

Select a Central Repository

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

About Collecting Statistics in Repositories

Register Central Repositories

Push Statistics to Central Repository

Register and Group Server Instances

LiteSpeed requires the following privileges and grants:

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.

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.

   Scenario: Click Import and then From Central Repository. Select the central repository to import server instances from, review the list of servers, optionally deselecting those you do not want to be registered in your LiteSpeed UI Console, click OK and continue with step 4.

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 (Site Message).
   • 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.

Related Topics

Select a Central Repository

Create Server Groups