PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Microsoft SQL Server data protection and replication requirements

PowerProtect Data Manager can manage and monitor data protection and replication for Microsoft SQL Server assets through integration with the Microsoft application agent.

After installing the Microsoft application agent, review the following information for additional requirements before adding the Microsoft application agent as an asset source in PowerProtect Data Manager and discovering the Microsoft SQL Server assets.

Verify that the environment meets the following requirements:

• Ensure that you do not mix 32-bit and 64-bit instances on the same Microsoft SQL Server host.

  PowerProtect Data Manager operations do not support hosts with a mix of 32-bit and 64-bit Microsoft SQL Server instances.

• Ensure that all clocks on the Microsoft SQL Server host, domain controller, and PowerProtect Data Manager are time-synced to the local NTP server to ensure discovery of the backups.
• Ensure that the Microsoft SQL Server and the PowerProtect Data Manager system network can see and resolve each other.
• Ensure that the port to be selected as the PowerProtect Data Manager communications port from the port ranges 7000 to 7009 and 7012 to 7020 is open on the Microsoft SQL Server host. Port 7000 is the default communications port. VM Direct supports only the default port 7000.
• Ensure that port 8443 is open on the Microsoft SQL Server host. This requirement applies only to VM Direct.
• Ensure that DNS is configured correctly on the application agent host for Microsoft SQL Server.
• Ensure that DNS is configured correctly on the PowerProtect Data Manager host and the name resolution matches.

• Ensure that the Microsoft SQL Server host was not previously registered to PowerProtect Data Manager using a different protection type, either Application Direct or VM Direct.

  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.