Using DPM 2012 Administrator Console to connect to DPM 2010 servers is now possible thanks to the DPM team. I noticed right away it requires SQL Server to connect to. The error below reports that its unable to connect to the DPM database instance.
To fix this issue you will want to add the SQL Server Browser and SQL Server port. Below explains which firewall rules to add.
Find your SQL Server port by using SQL Server Configuration Manager on the DPM server. You will want to use this Dynamic port for the firewall rule.
As an alternitivate you could just as the SQL Server application to the firewall rule. But I’m going to do port based for this example.
Here I enter my dynamic SQL Server port to the firewall rule.
Allow the connection for this rule.
For profiles I selected all as a default. For a domain environment you could go with domain level.
Do the same for SQL Server Browser which is port 1434 protocol UDP.