Thursday, October 6, 2011

DPM 2010–Unable to connect to DPM database instance

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.

image

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.

image

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.

image

Here I enter my dynamic SQL Server port to the firewall rule.

image

Allow the connection for this rule.

image

For profiles I selected all as a default. For a domain environment you could go with domain level.

image

Do the same for SQL Server Browser which is port 1434 protocol UDP.

No comments: