Registering an Application Server - SQL

Edit online

Before you begin

  • Create a site to assign to your provider. A site is a user-defined grouping of providers that is generally based on location. See Adding a site.
  • When registering providers it is recommended to assign all related sources, such as hosting vCenters and related storage systems, to the same site.
  • Review system requirements - Microsoft SQL requirements
  • For application server it is recommended to keep all resources, such as hosting vCenters and related storage systems, configured in the same site.
  • When registering physical SQL servers it is recommended to register via the DNS server. The IBM Storage Defender Copy Data Management appliance must be resolvable and route-able by the DNS server; the physical SQL server will communicate back to IBM Storage Defender Copy Data Management through DNS.
  • Note that for physical SQL servers, you must allow outgoing connections to port 8443 on the IBM Storage Defender Copy Data Management appliance from the SQL server.
  • Note: To successfully catalog a virtual SQL application provider, you must also register associated vCenters.

Procedure

To register an Application Application Server - SQL, complete the following steps:
  1. Click the Configure tab. On the Views pane, select Sites & Providers, then select the Providers tab.
  2. In the Provider Browser pane, select Application Server.
  3. Right-click Application Server. Then click Register. The Register Application Server dialog opens.
  4. Select SQL as the Application Type.
  5. Populate the fields in the dialog:
    Site
    A user-defined provider location, created in the Sites & Providers view on the Configure tab.
    Name
    A user-defined name for the SQL server. This can be the same as the host name or it can be a meaningful name that is used within your organization to refer to the provider. Provider names must be unique.
    Host Address
    A resolvable IP address or a resolvable path and machine name.
    Port
    The communications port of the provider you are adding. The default port is 5985.
    In previous versions of IBM Storage Defender Copy Data Management, the default SQL port was 1443.
    SQL providers that were registered in previous versions using port 1443 will continue to function in newer versions of IBM Storage Defender Copy Data Management.
    Run Inventory job after registration
    If selected, IBM Storage Defender Copy Data Management creates a high-level inventory job and automatically catalogs the objects on the provider. Note that the inventory job may take considerable time to complete.
    Type
    Select a Virtual or Physical SQL server type. Select Virtual if the SQL server is a VMware virtual machine.
    If selecting Virtual, enter the vCenter location of the SQL application server in the vCenter field.
    vCenter
    The vCenter location of the virtual SQL application server.
    System Credential:
    Select or create your SQL credentials. See Identities overview.
    Note: For Kerberos-based authentication only, the user identity must be specified in the username@FQDN format. The username must be able to authenticate using the registered password to obtain a ticket-granting ticket (TGT) from the key distribution center (KDC) on the domain specified by the fully qualified domain name.
  6. Click OK. IBM Storage Defender Copy Data Management first confirms a network connection and then adds the provider to the database.

    To troubleshoot an application server after registration, use the Test & Configure option. This option verifies communication with the server, tests DNS settings between the IBM Storage Defender Copy Data Management appliance and the server, and installs an IBM Storage Defender Copy Data Management agent on the server. From the Provider Browser pane, right-click the application server, then click Test & Configure.

    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.