PowerProtect Data Manager: How to Install and Register PowerProtect Data Manager SQL Agent

Confirm that sysadmin privilege is set for NT AUTHORITY\SYSTEM account as it is the account used by PowerProtect Data Manager SQL agent by default.

Installation

1. Download PowerProtect Data Manager SQL Agent from the UI.
   
   Figure 1: Where to download PowerProtect Data Manager SQL Agent from UI
   
    
   Figure 2: Screenshot of Microsoft SQL Server tab in Downloads

2. Copy the package to the SQL server and run it with admin privileges. Accept the license agreement and go to next.
   
   Figure 3: Copy the package and accept license agreement

3. Define install path, by default, C:\Program Files\DPSAPPS\MSAPPAGENT.
   
   Figure 4: Define the install path to C:\Program Files\

4. Configure install options.
   
   Figure 5: Screenshot of the different install options

   • SMSMS Plugin is selected by default and installs a plug-in into the SQL Server Management Studio console to allow Self-Service operations.
   • Granular Recovery (Optional): This is not checked by default. If selected, it installs Item Point software used to perform Granular restores.

• PowerProtect Data Manager: This is not checked by default. This option must be validated in order to integrate SQL Agent within the PowerProtect Data Manager appliance. If not selected, only Self-Service operations are allowed.

5. Proceed with installation.
   
   Figure 6: Screenshot of package installation progress

6. Select if Common Language Runtime (CLR) is to be installed. This allows CLR-integrated TSQL functions to run.
   
   Figure 7: Select if the Common Language Runtime (CLR) is to be installed 

7. Wait for the install to complete.
   
   Figure 8: Setup completion screen

Registration

1. Once the install procedure is completed, PowerProtect Data Manager Agent automatically attempts to register the new agent within the PowerProtect Data Manager appliance, which can be confirmed on PowerProtect Data Manager UI > Infrastructure > Applications agents.
   
   Figure 9: Screenshot of PowerProtect Data Manager Agent automatically registering the new agent

2. If required, agents can be registered manually by running the register.bat script, located under the C:\Program Files\DPSAPPS\AgentService folder.
   
   Figure 10: Screenshot of script to manually register the new agent

3. After a successful registration, the PowerProtect Data Manager Agent runs a full discovery of the available assets for this host.
   
   Figure 11: After registration, the PowerProtect Data Manager Agent runs a full discovery of available assets

4. Similar to the registration process, manual discovery operations can be run from PowerProtect Data Manager UI > Infrastructure > Asset Sources.
   
   Figure 12: Screenshot of manually discovering assets from the PowerProtect Data Manager UI

5. For any registration or discovery-related issue, logs are located under c:\program Files\DPSAPPS\AgentService\Logs folder.
   
   Figure 13: Location of log files for reference should any registration or discovery issues occur