Configuration
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
-
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.
-
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.
-
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.
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
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. |
Click hereTIP: 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.
- Select Home | SQL Server Registration | Manage.
-
Click Add server to add an individual server or Import to import server instances from a CSV file or the LiteSpeed central repository
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.
-
(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;321NOTE: 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.
-
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.
-
(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
- Right-click a server in the Server tree in the navigation pane and select Edit | SQL Server Registration.
- Clear the Allow import of this instance... checkbox and click OK.
Create Server Groups
To create server groups
-
Select the Backup Manager pane (CTRL+1).
-
Group the Backup Manager tree by server group (View | Group Instances By | Server Groups).
-
Select one of the following options:
Create a top-level server group
Right-click SQL Servers at the top of the navigation tree and select New SQL Server Group.
Create a subgroup of an existing server group
Right-click the group in the navigation pane tree and select New SQL Server Group.
Tips:
- To create multi-level groups, create the parent group first. When you create the subgroup, the parent group will already be there for you to select.
- To edit or delete a server group, right-click the group and select the appropriate option.
- You can also group server instances by categories. To switch between server groups and categories, select View | Group Instances By. For more information, see Change Server Instance Grouping Methods.