Search This Blog

Friday, June 28, 2013

Remote SQL for DPM 2012 R2 Requirements


Let get our hand dirty by installing DPM 2012 R2 (Preview Edition). Installation on DPM is still remain the same except on this page. We can now make the DPM database high availability by placing it on SQL cluster.


During installation, you can select stand alone or SQL cluster.

Here is some guidelines which I’ve configure on my test lab environment when using remote SQL Server.

On Remote SQL Server

a) Install DPM Remote SQL Prep from the media kit.


b) Using SQL Configuration Manager to configure

SQL Server Agent – Automatic & Running

SQL Browser –Automatic & Running

c) Create DPMDBReaders$<DPM server name> and DPMDBAdministrators$<DPM server name> local groups on the remote SQL Server. Add DPM Administrator account into these group.

d) Configure Windows exception to llow SQLServer.exe to use port 80.

e) SQL Server is install with default collation. On remote SQL server, do remember to install the SQL Reporting.

For more info, please visit