PowerProtect Data Manager 19.17 Microsoft SQL Server User Guide

Update the Microsoft application agent

The Microsoft application agent 19.17 supports a direct update from any supported version to the latest version.

1. Launch emcmsappagent-19.17.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 Granular Recovery 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. Select the option to enable the PowerProtect Data Manager communications port by creating the Windows firewall rule that grants the agent service inbound and outbound access.

   NOTE:

   The Microsoft application agent requires a selected port on Microsoft SQL Server (selected from port ranges 7000 to 7009 and 7012 to 7020) 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 you do not select a port from the port ranges, the default port 7000 is used as the communications port.

   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 the CLR assembly, select one of the following authentication options:

      NOTE:When you change or repair an existing Microsoft application agent installation, the Microsoft application agent registers the CLR assembly with any new Microsoft SQL Server instances that were installed. The authentication option that is used is the one selected as follows with the initial installation.
      • 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.

If the update of the Microsoft application agent fails, complete the following steps:

1. Save a copy of the existing DPSAPPS folder.
2. Uninstall the Microsoft application agent from Control Panel > Programs > Programs and Features.
3. Install the Microsoft application agent.
4. Replace the DPSAPPS folder with the copy that was saved in step 1.