Share via

DPM 2012 R2 proof of concept with SQL 2014

  • Article

Overview:

The following article will cover a basic install of Data Protection Manager 2012 R2 and how to use it alongside SQL 2014. A server with SQL and DPM installed on it will be deployed.  This can be used as a template, a pilot or a POC for a customer.  It is intended as a general template and as such will need to be modified to your own specific needs and processes.  

This is not an architecture guide or intended to be a design guide in any way. This is provided "AS IS" with no warranties and confers no rights. Use is subject to the terms specified in the Terms of Use.

Server Names\Roles:

SCDPM01 DPM server, , SQL Database Services, Reporting Services

Windows Server 2012 R2 will be installed as the base OS for all platforms.  All servers will be a member of the AD domain.

High-Level Process:

  1. In AD, create the following accounts and groups, according to your naming convention:
    1. DOMAIN\DPMAdmins  DPM Administrators group
    2. DOMAIN\DPMSQL SQL service account
  2. Add the domain user accounts for yourself and your team to the “DPMAdmins” group.
  3. Install Windows Server 2012 R2 to all server role servers.
  4. Install Prerequisites and SQL 2012 with SP1.
  5. Install the DPM Server
  6. Upgrade DPM to the latest version
  7. Upgrade SQL 2012 to SQL 2014

Prerequisites:

  1. Install Windows Server 2012 R2 to the server

  2. Join the server to domain

  3. Install all available Windows Updates.

  4. Add the “DPMAdmins” domain global group to the Local Administrators group on the DPM server 

  5. Install .Net 3.5SP1

  6. Install SQL 2012 with SP1 on the server

    1. The setup is fairly straight forward.  Consult your DBA team to ensure your SQL deployment is configured for best practices according to your corporate standards.
    2. Run setup, choose Installation > New Installation…
    3. When prompted for feature selection, install ALL of the following:
    4. Database Engine Services
    5. Full-Text and Semantic Extractions for Search
    6. Reporting Services - Native
    7. Management Tools – Basic and Complete (for running queries and configuring SQL services)
    8. On the Instance configuration, choose a default instance, or a named instance. 
    9. On the Server configuration screen, set SQL Server Agent to Automatic.  Input the DOMAIN\dpmsql account and password for Agent, Engine, and Reporting.
    10. On the Collation Tab – you can use the default which is SQL_Latin1_General_CP1_CI_AS or choose another supported collation.
    11. On the Account provisioning tab – add the DPMAdmins global group here. This will grant more rights than is required to all DPMAdmin accounts but is fine for testing purposes of the POC.
    12. On the Data Directories tab – set your drive letters correctly for your SQL databases, logs, TempDB, and backup.
    13. On the Reporting Services Configuration – choose to Install and Configure. 
    14. Setup will complete. Restart as necessary.

  7. Install DPM on the server

    1. Run Setup.exe
    2. In the Install list, click Data Protection Manager.
    3. Accept the license and click OK.
    4. On the Welcome page, click Next
    5. Choose to use stand alone SQL server, and input server name.  Input your credentials that have rights to this server and the SQL server and instance, and choose “Check and Install”.
    6. Resolve any prerequisite issues.  Click Next.
    7. Input the Product key, and click Next.
    8. Choose an install path, click Next.
    9. Chose to use Windows Update or not, click Next.
    10. Choose to join the CEIP or not, Next.
    11. Click Install.
    12. Setup will complete. Restart as necessary.

  8. Launch SQL management studio and connect to your instance, check that the DPM database has been created.  Log into the DPM console and check that it launches okay.  

  9. Download the latest update for DPM 2012, at the time of writing this, is Update Rollup 13 Install Update Rollup 13

    1. Run the Setup and click Next
    2. Accept the license and click Install
    3. Setup will complete. Restart as necessary.

  10. Log into the DPM console and check that it launches okay.  

  11. Mount the SQL 2014 media.  

    1. Run setup, choose Installation > Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012/p>
    2. On the Product Key page accept the default and select Next
    3. Accept the license terms and select Next
    4. Check the Instance is the correct one and select Next
    5. Confirm the features you want to upgrade and select Next
    6. Confirm the Instance Configuration and select Next
    7. Confirm the Server Configuration and select Next
    8. Select the Full-Text Upgrade mode that you wish to use, Import is the recommended and select Next
    9. Click Upgrade
    10. Setup will complete. Restart as necessary.

  12. Launch SQL management studio and check your instance. Log into the DPM console and check that it launches okay.  

  13. Download the latest Cumulative Update for SQL, at the time of writing this is CU5.

  14. Launch the CU5 install. 

    1. Accept the license terms and select Next
    2. Select the features to be upgraded and select Next
    3. The wizard will check for files in use, once complete select Next
    4. Click Upgrade
    5. Setup will complete. Restart as necessary.
    6. Your DPM install is now ready to be used.