PowerProtect Data Manager 19.12 Microsoft SQL Server User Guide

Update the Microsoft application agent

If you are using the latest version of PowerProtect Data Manager, the Microsoft application agent 19.12 supports a direct update from version 19.8 or later.

1. Launch emcmsappagent-19.12.0.0.exe. The installation wizard appears.
2. On the Welcome Wizard page, select I agree to the license term and agreements, and then click Next.

3. By default, the PowerProtect Data Manager option is selected and the IP address is displayed. If these components were installed in the previous version, SSMS Plug-in and ItemPoint are also selected.

   Whether the PowerProtect Data Manager option was previously selected or you select the option during this update, you can change the firewall rule setting by the Configure the Windows Firewall option under Common Core Components. Select the option to enable the PowerProtect Data Manager communications port 7000 by creating the Windows firewall rule that grants the agent service inbound and outbound access.

   NOTE

   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.

   Click Upgrade.

4. On the CLR assembly deployment wizard page, perform the following steps:

   NOTE When you deploy the CLR assembly during the Microsoft application agent update, the deployment creates a Microsoft SQL Server login with the name ddbmaCLRExtLogin. The CLR procedures run under this account.
   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 CLR assembly, select one of the following authentication options:

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