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 (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;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.