Adding an SQL Server application server

Edit online

When an SQL Server application server is added, an inventory of the instances and databases that are associated with the application server is captured and added to IBM Storage® Protect Plus. This process enables you to complete backup and restore jobs, as well as run reports.

Procedure

Restriction: You can assign only one application server or file server per host. For example, if you register a host as a Microsoft Windows™ file system, you cannot register the same host as a Microsoft SQL Server or a Microsoft Exchange Server.
To add an SQL Server host, complete the following steps.
  1. In the navigation panel, click Manage Protection > Databases > SQL.
  2. Click Manage Application Servers.
  3. Click Add Application Server.
  4. Populate the fields in the Application Properties pane:

    Host Address

    Enter the resolvable IP address or a resolvable path and machine name in the Host Address field.

    Get SSL certificate thumbprint

    Get the SSL certificate thumbprint for the Windows-based host. You must complete this step when registering servers for the first time or if the certificate on the server changes. This setting will only be visible if you set the global preference Windows Clients Port (WinRM) used for application and file indexing to 5986. For more information about global preferences, see Configuring global preferences.

    The HTTPS listener must be enabled on the host. You must create a self-signed certificate and then enable the HTTPS listener if it is not already enabled. For more information, see How to configure WinRm for HTTPS.

    When upgrading to IBM Storage Protect Plus 10.1.9, systems that are already registered in the previous version are set to trust on first use (TOFU) and the certificate thumbprint will automatically be added to the registration information in the catalog.

    SSL certificate thumbprint

    The SSL certificate thumbprint is displayed here. Confirm that the certificate thumbprint matches the thumbprint of the certificate on the host that you are adding.

    Use existing user

    Enable to select a previously entered user name and password for the provider.

    UserID

    Enter your user name for the provider. The user identity follows the default domain\name format if the virtual machine is attached to a domain. The format local _administrator is used if the user is a local administrator.

    Password

    Enter your password for the provider.

    Maximum concurrent databases

    Set the maximum number of databases to back up concurrently on the server. Server performance is impacted when backing up a large number of databases concurrently, as each database utilizes multiple threads and consumes bandwidth when copying data. Use this option to control the impact on server resources and minimize the impact on production operations.

  5. Click Save. IBM Storage Protect Plus confirms a network connection, adds the application server to the IBM Storage Protect Plus database, and then catalogs the instance.
    If a message appears indicating that the connection is unsuccessful, review your entries. If your entries are correct and the connection is unsuccessful, contact a system administrator to review the connections.

What to do next

After you add the SQL Server application server, complete the following action:
Action How to
Assign user permissions to the application server. See Creating a role.