PowerProtect Data Manager 19.12 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. Click , and then select Downloads from the System Settings menu.
   2. Under Microsoft SQL Server, select Download Agent.
      The Microsoft application agent download package, msappagent1912_win_x64.zip, is downloaded.
   3. Upload the package to the Microsoft SQL Server host on Windows.
   NOTE To verify the authenticity and integrity of the downloaded package, follow the instructions in the PowerProtect Data Manager Security Configuration Guide.
2. Open msappagent1912_win_x64.zip with WinZip.
3. Use WinZip to extract the msappagent1912_win_x64.zip file.
4. In the extracted folder, launch emcmsappagent-19.12.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 in the Data Paths group box.

       NOTE

       The Microsoft application agent supports only the Application Direct and VM Direct workflows.

       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 in the Common Core Components group box.

       2. 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.

       3. In the Appliance hostname or IP address field in the PowerProtect Data Manager Registration group box, 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.

   • To install the VM Direct Engine onto a virtual machine that is not part of a protection policy, so as to recover application-aware virtual machine backups from a differential virtual machine, 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.

     As part of centralized restores, PowerProtect Data Manager also has centralized management for installing the Microsoft application agent on the virtual machine application-aware host that acts as a recovery-only host.

     • Select VM Direct in the Data Paths group box.

       NOTE

       The PowerProtect Data Manager appliance details are disabled when you select the VM Direct 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.
       Deploying the CLR assembly enables you to run the T-SQL backup and restore scripts that use the CLR-integrated T-SQL functions.
    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

       NOTE The option Enable Storage Direct Stored Procedures is not applicable to Application Direct and VM Direct workflows.
    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.