PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Discover a Microsoft SQL Server application host

After you register an application host with PowerProtect Data Manager, the host appears in the Asset Sources window. Then you can select the host, perform discovery, and modify the application host credentials. For application hosts, discovery is required if you want to schedule a backup. Assets must also be discovered for the centralized copy management of self-service backups.

1. Select Infrastructure > Asset Sources.
   The Asset Sources window appears.
2. Select the SQL tab.
3. If you are adding a Microsoft SQL Server database, select the host entry and click Edit Credentials.

   The Edit Credentials dialog appears.

   NOTE:The supported syntax for credentials is <user>@<host> or <user>@<domain>. The syntax <host>\<user> or <domain>\<user> is not supported.
4. If you are adding credentials for a Microsoft SQL Server database, ensure that you specify the OS credentials for the Microsoft SQL Server host. Ensure that these credentials have the rights to perform the Microsoft SQL Server backup and restore operations.
5. Click Save.
6. On the SQL tab, select the application host and then click Discover.

   The Initiate Discovery dialog appears with an option to immediately start a full discovery of the assets on the host.

   NOTE:On the SQL tab, you can click Discover at any time if any additions or other changes to your Asset Sources have taken place outside of the PowerProtect Data Manager environment. Asset discovery is also initiated by default after registration of the host to PowerProtect Data Manager and at hourly intervals. Discovery time is based on networking bandwidth. Each time you initiate a discovery process, the resources that are discovered and those that are handling the discovery impact the system performance.
7. Click Yes.