PowerProtect Data Manager 19.11 Microsoft SQL Server User Guide

Install the Microsoft application agent with the wizard

Learn how to install the Microsoft application agent with the installation wizard.

1. In the PowerProtect Data Manager UI:
   1. Select Agent Downloads from the System Settings menu.
   2. Select the Microsoft application agent download package, msappagent1911_win_x64.zip.
   3. Download the package to the host where you want to install the Microsoft application agent.
   NOTE To verify the authenticity and integrity of the downloaded package, follow the instructions in the PowerProtect Data Manager Security Configuration Guide.
2. Open msappagent1911_win_x64.zip with WinZip.
3. Use WinZip to extract the msappagent1911_win_x64.zip file.
4. In the extracted folder, launch emcmsappagent-19.11.0.0.exe.
   The installation wizard appears.
5. On the Welcome Wizard page, select I agree to the license term and agreements, and then click Next.
6. On the Change Install Location page, perform one of the following tasks:

   • To install the Microsoft application agent in the default folder, leave the installation location as is.

     The default installation folder is C:\Program Files\DPSAPPS\MSAPPAGENT.

   • To specify a different installation location, perform the following steps:

     1. Click Change.
     2. In the dialog box that appears, specify the installation location.
     3. Click OK.
7. Click Next.
8. On the Configure Installation Options page, specify any of the following installation options, as required:
   • To integrate the Microsoft application agent with PowerProtect Data Manager for centralized or self-service protection of Microsoft SQL Server data, select the following options, as required:

     • To install the Microsoft application agent software, select Application Direct.

       NOTE

       Ensure that the Microsoft SQL Server host was not previously registered to PowerProtect Data Manager with the VM Direct option or as part of a virtual machine application-aware protection policy.

       For example, if the Microsoft SQL Server host was previously registered to PowerProtect Data Manager with VM Direct during the Microsoft application agent installation, the protection type for that host may not be changed to Application Direct, even if the Microsoft application agent is uninstalled.

     • To install the SQL Server Management Studio (SSMS) plug-in user interface, select SSMS Plug-in.

       You can use the SSMS plug-in to perform self-service Microsoft SQL Server backup and restore operations.

     • To enable table-level restores, select ItemPoint.

       This option installs ItemPoint for Microsoft SQL Server, which you can use to perform table-level restores.

     • Specify the PowerProtect Data Manager appliance details by performing the following steps:
       1. Select PowerProtect Data Manager.

       2. In the Appliance hostname or IP address field, type the hostname or IP address of the PowerProtect Data Manager server.

          NOTE If you specify a hostname or fully qualified domain name (FQDN) with an underscore (_) for the PowerProtect Data Manager server, then the communication will be done by the system's IP, if provided by the system on registration.

       3. To enable the PowerProtect Data Manager communications port 7000, ensure that the Configure the Windows Firewall option is selected under Common Core Components. This option is selected by default.

          NOTE

          When the Configure the Windows Firewall option is enabled, the installation creates the Windows firewall rule that allows inbound and outbound connections for the agent service process. Installation of the Microsoft application agent requires port 7000 on Microsoft SQL Server and port 8443 on PowerProtect Data Manager to be open bidirectionally. These ports enable communication between the Microsoft application agent and PowerProtect Data Manager.

          If the File System agent is already installed and firewall rules are configured, then the Configure the Windows Firewall option is selected by default but disabled for the Microsoft application agent.

   • To install the VM Direct Engine to recover application-aware virtual machine backups, select the following options, as required:

     NOTE By default, when a Microsoft SQL Server virtual machine is added to a virtual machine application-aware protection policy in PowerProtect Data Manager, the Microsoft application agent and ItemPoint are silently installed on the protected virtual machine. Before you restore a VM Direct Engine backup to an alternate virtual machine that is not part of a protection policy, you must install the Microsoft application agent on the target virtual machine.

     • Select VM Direct Engine.

       NOTE

       The PowerProtect Data Manager appliance details are disabled when you select the VM Direct Engine option.

       Ensure that the Microsoft SQL Server host was not previously registered to PowerProtect Data Manager with the Application Direct option.

       For example, if the Microsoft SQL Server host was previously registered to PowerProtect Data Manager with Application Direct during the Microsoft application agent installation, the protection type for that host may not be changed to VM Direct, even if the Microsoft application agent is uninstalled.

     • To install the SQL Server Management Studio plug-in user interface, select SSMS Plug-in.

     • To enable table-level restores, select ItemPoint.

       This option installs ItemPoint for Microsoft SQL Server, which you can use to perform table-level restores.

9. Click Install >.
10. On the CLR assembly deployment wizard page, perform the following steps:
    1. Select or clear the Microsoft SQL Server instances on which you want to deploy the CLR assembly. By default, all the Microsoft SQL Server instances are selected.
    2. To deploy the CLR assembly, select one of the following authentication options:
       NOTE When you deploy the CLR assembly during the Microsoft application agent installation, the deployment creates a Microsoft SQL Server login with the name ddbmaCLRExtLogin. The CLR procedures run under this account.

       • Current Windows User
       • Use Windows Authentication
       • Use Database Authentication
    3. In the User name and Password fields respectively, type the username and the password of the user who has the privileges to deploy the CLR assembly.
    4. Click Deploy.
    5. Click Install.
    6. After the deployment is complete, click Next.
11. On the Complete the Setup page, click Finish.