PowerProtect Data Manager 19.10 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 port 7000 is open on the Microsoft SQL Server host.
• 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.