Install System Center 2019 Data Protection Manager on Windows Server 2019 and SQL Server 2017

7 min read

Introduction

Microsoft announced the release of System Center 2019 under Long-Term Servicing Channel (LTSC). LTSC provides 5 years of standard and 5 years of extended support. Subsequent the release of System Center 2019, the suite will continue to accrue value through the Update Rollup releases every six months over the mainstream support window of 5 years. Microsoft has dropped Semi-Annual Channel (SAC) releases, but new features before the next Long-Term Servicing Channel (LTSC) release will be delivered through Update Rollups. You can read about the announcement on Windows Sever Blog. You can download the media from the Volume Licensing Service Center (VLSC), or you can download the evaluation bits from the following link.

There are a lot of improvements and new features were introduced in this release.

In System Center 2019 Data Protection Manager, Microsoft added several new features:

  • VMware backup to Tape
  • Newer workloads backup support
  • Faster Backup using SSD Tiered Storage
  • VMware parallel backups
  • Monitoring DPM in Azure
  • DPM disaster recovery: Backup DPM DB
  • Windows Server 2019 support
  • SQL Server 2017 as DPM database
  • Learn more

In this post, I will show you how to install System Center 2019 Data Protection Manager on top of Windows Server 2019 and SQL Server 2017. In a follow-up blog post, I will dive into the new features and improvements.

Prepare DPM 2019 Installation

The following prerequisites and components should be installed on the server, before you install DPM:

  • PowerShell 5.0 or later.
  • .NET 3.5.
  • SQL Server 2017.
  • SQL Server Management Studio (SSMS).
  • SQL Server 2017 Reporting Services (SSRS).
  • Open port 443, 1433 and 1434 in Windows Firewall.
  • Ensure that a domain controller for the Active Directory domain is available.

Install DPM 2019 on Windows Server 2019 and SQL Server 2017

The installation of DPM is straightforward using the graphical user interface (GUI). In this article, I will show you how to automate the installation of System Center 2019 Data Protection Manager and SQL Server 2017 on top of Windows Server 2019. DPM 2019 can also be installed on Windows Server 2016 so you can follow the same steps.

Automate SQL Server 2017 Installation

Please note that System Center 2019 Data Protection Manager supports local and remote SQL Instance. You can disregard this step if you already have SQL server deployed locally or on another server in your environment.

Assuming your DPM server is connected to the internet, open Windows PowerShell and run the following command to install NetFx3 from Windows Update just as if we had checked the box in Windows Features:

Dism /Online /Enable-Feature /FeatureName:NetFx3 /All

Mount SQL Server 2017 Standard media and then open an elevated command prompt window, then navigate to the SQL Server 2017 media, and run the following command on a single line:

Make sure to update the domain name, SQL service accounts and passwords according to your environment. As a side note, you can also use a parameter (configuration) file and pass it to the setup for SQL instead of typing the long CLI below, either way will work. For more information on how to install SQL Server using a configuration file, please check the following article. To specify the configuration file at the command prompt, use the following syntax: Setup.exe /ConfigurationFile=”D:\MyConfigFile.ini”

Setup.exe /Q /ACTION=install /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQLEngine
/INSTANCENAME=DPM2019 /INSTANCEDIR="D:\Program Files\Microsoft SQL Server"
/INSTALLSHAREDWOWDIR="D:\Program Files (x86)\Microsoft SQL Server"
/INSTALLSHAREDDIR="D:\Program Files\Microsoft SQL Server"
/SQLSVCACCOUNT="VIRT\sqldpm" /SQLSVCPASSWORD="dpm2019+1"
/SQLSYSADMINACCOUNTS="VIRT\sqldpm" /AGTSVCACCOUNT="VIRT\sqldpm" /AGTSVCPASSWORD="dpm2019+1"
/AGTSVCSTARTUPTYPE="Automatic" /SECURITYMODE=SQL /SAPWD="dpm2019+1"
/SQLTEMPDBDIR="D:\Program Files\Microsoft SQL Server\TempDB\\"
/SQLUSERDBDIR="D:\Program Files\Microsoft SQL Server\SQLData\\"
/SQLUSERDBLOGDIR="D:\Program Files\Microsoft SQL Server\SQLLog\\"

After short period of time, the installation will complete successfully as shown in the next screenshot:

Starting with SQL 2016 onward, SQL Server Reporting Services (SSRS) and SQL Server Management Studio (SSMS) are now packaged and installed separately with only a web link to each download page within the SQL Server Installation Center. At the time of writing, SSMS version 17.9.1 is the current General Availability (GA) which you can download from here, and SQL Server 20127 Reporting Services is the current version which you can download from here.

Within the same command prompt window, type the following command to install SQL Server Management Studio (SSMS) in silent mode. SSMS installation will take around 5 to 10 minutes to complete.

SSMS-Setup-ENU.exe /install /quiet /norestart /log log.txt

Within the same command prompt window, type the following command to install Microsoft SQL Server 2017 Reporting Services (SSRS) as Developer free edition in silent mode. Please note that SSRS must be installed on the C:\ volume otherwise DPM installation will fail with Error ID 812.

SQLServerReportingServices.exe /quiet /InstallFolder="C:\Program Files\Microsoft SQL Server Reporting Services" /norestart /IAcceptLicenseTerms /Edition=Dev

Finally, run the following PowerShell commands to open all necessary firewall ports:

New-NetFirewallRule -DisplayName 'DPM SQL Server' -Name 'DPM SQL Server' -Description 'DPM SQL Server' -Program "D:\Program Files\Microsoft SQL Server\MSSQL14.DPM2019\MSSQL\Binn\sqlservr.exe" -Action Allow -Profile Domain -Direction Inbound

New-NetFirewallRule -DisplayName 'DPM UDP Port 1434' -Name 'DPM UDP Port 1434' -Description 'DPM UDP Port 1434' -Action Allow -LocalPort 1434 -Protocol UDP -Profile Domain -Direction Inbound

New-NetFirewallRule -DisplayName 'DPM TCP Port 1433' -Name 'DPM TCP Port 1433' -Description 'DPM TCP Port 1433' -Action Allow -LocalPort 1433 -Protocol TCP -Profile Domain -Direction Inbound

New-NetFirewallRule -DisplayName 'SQL Server Reporting Services (SSRS)' -Name 'SSRS' -Description 'SQL Server Reporting Services (SSRS)' -Action Allow  -LocalPort 80,443 -Protocol TCP  -Profile Domain -Direction Inbound

Configure SQL Server 2017 Reporting Services

As mentioned earlier, starting with SQL 2016 onward, SQL Server Reporting Services (SSRS) is now packaged and installed separately. So after the installation is completed, the Reporting Services instance (named SSRS) is unconfigured. It’s required to configure SSRS before you proceed and install DPM 2019.

The Report Server Configuration Manager GUI is available to configure it. It’s very important to follow the steps below in sequence before you install DPM 2019 otherwise the installation will fail with Error ID 812.

  • Open the Report Server Configuration Manager GUI and connect to the Report Server Instance (SSRS).
  • Select the Service Account and change the built-in account from Virtual Service Account to Network Service and then click Apply.

  • Select the Web Service URL, in this step you need to update the Virtual Directory name with underscore followed by the name of your DPM server name (i.e. ReportServer_DPM2019), and then click Apply.

  • Select the Database and then click Change Database. Choose Create a new report server database and then click Next.

  • Enter the server name followed by the SQL Server instance name, choose Authentication Type and then click Test Connection. If the test connection succeeded, then click on Next to continue.

  • Leave the default Database Name (ReportServer) and then click on Next to continue.
  • In the Credentials step, make sure that the Authentication Type is set to Service Credentials. Click on Next to continue.
  • In the Summary page, review the information that will be used to create a new report server database. Click on Next to continue.

  • Wait until the Report Server Database Configuration is completed and then click on Finish.

  • Select the Web Portal URL, in this step you need to update the Virtual Directory name with underscore followed by the name of your DPM server name (i.e. Reports_DPM2019), and then click Apply.

  • Once you configured SQL Server Reporting Services, open SQL Server Management Studio (SSMS) and verify you are able to connect to the SQL instance name that you specified in the previous step. You can see the ReportServer database is also created.

Now we are ready to install DPM 2019.

Automate DPM 2019 Installation

DPM supports item-level recovery (ILR) which allows you to do granular recovery of files, folders, volumes, and virtual hard disks (VHDs) from a host-level backup of Hyper-V virtual machines. Thus, the Microsoft Hyper-V Role and PowerShell Management Tools windows feature should be installed. This is required for Data Protection Manager to run correctly.

Open an elevated command prompt window and type the following, this command will also restart the DPM server.

dism.exe /Online /Enable-feature /All /FeatureName:Microsoft-Hyper-V /FeatureName:Microsoft-Hyper-V-Management-PowerShell /quiet

Copy the following configuration file into Notepad and save it on the DPM server (i.e. DPMSetup.ini). You can use the same configuration below whether the SQL Server instance is installed on the DPM server or on a remote server.

When creating DPMSetup.ini, replace the text inside < > with the proper values from your environment.

[OPTIONS]
UserName=<Domain-name\Username>
CompanyName=The Power MVP Elite
ProductKey=XXXX-XXXX-XXXX-XXXX-XXXX
SqlAccountPassword=<The password for the SQL sa account>
ProgramFiles=D:\Program Files\
DatabaseFiles=D:\Program Files\
IntegratedInstallSource=D:\SCDPM2019
SQLMachineName=<Name of the SQL Server Computer> OR <SQL Cluster Name>
SQLInstanceName=DPM2019
SQLMachineUserName=<Domain-name\Username>
SQLMachinePassword=<Password for the user name Setup must use>
SQLMachineDomainName=<Domain name to which the SQL Server computer is attached to>
ReportingMachineName=<Name of the SQL Server Computer> OR <SQL Cluster Name>
ReportingInstanceName=SSRS
ReportingMachineUserName=<Domain-name\Username>
ReportingMachinePassword=<Password for the user name Setup must use>
ReportingMachineDomainName=<Domain name to which the SQL Server computer is attached to>

After saving the file, at an elevated command prompt window on the DPM server, type the following:

start /wait D:\SCDPM2019\setup.exe /i /f D:\DPMSetup.ini /l D:\dpmlog.txt

D:\SCDPM2019\ indicates the media location where you’ll run setup.exe from, and D:\DPMSetup.ini is the location path of the .ini file.

After short period of time, DPM 2019 will be installed automatically as shown in the following screenshot:

That’s it there you have it!

Learn more

Do you want to learn more about System Center Data Protection Manager and how to create a hybrid-cloud backup solution? Make sure to check my recently published book: Microsoft System Center Data Protection Manager Cookbook.

With this book (over 450 pages) on your side, you will master the world of backup with System Center Data Protection Manager and Microsoft Azure Backup Server deployment and management by learning tips, tricks, and best practices, especially when it comes to advanced-level tasks.

__
Thank you for reading my blog.

If you have any questions or feedback, please leave a comment.

-Charbel Nemnom-

About Charbel Nemnom 525 Articles
Charbel Nemnom is a Cloud Architect, ICT Security Expert and Microsoft Most Valuable Professional (MVP), totally fan of the latest's IT platform solutions, accomplished hands-on technical professional with over 17 years of broad IT Infrastructure experience serving on and guiding technical teams to optimize the performance of mission-critical enterprise systems. Excellent communicator is adept at identifying business needs and bridging the gap between functional groups and technology to foster targeted and innovative IT project development. Well respected by peers through demonstrating passion for technology and performance improvement. Extensive practical knowledge of complex systems builds, network design, business continuity, and cloud security.

Be the first to comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.