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.

Wednesday, October 5, 2011

DPM 2010 – Error Opening installation log file

While installing DPM 2010 updates you might encounter Error opening installation log file. This happened with pretty much any update attempted.  For the instance that I worked on was the folder was either deleted or never created on the DPM 2010 Server. Below is the error related to this article.

image

Creating the folder %systemdrive%\DPMLogs which for most servers is c:\DPMLogs as seen below

image

If the user has permissions to this folder you should get the updater to start running.

image

Log file should be created and if more issues arise you can check this log.

image