How to do it...

Make sure that your operating system is fully patched and rebooted before you start the installation. Now follow these steps:

1. Install the SQL Server instance:
   1. Mount the SQL Server 2016 media and then open the Command Prompt (cmd).
   2. Browse to the drive letter where SQL Server is mounted.
   3. Type in the following command to automate the installation of SQL Server and add all of the required features:

Setup.exe /Q /ACTION=install /IACCEPTSQLSERVERLICENSETERMS /FEATURES=SQLEngine,RS /INSTANCENAME=DPMINSTANCE /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” /SQLSYSADMINACCOUNTS=”VIRT\sqldpm” /SQLSVCPASSWORD="dpm2016+1" /RSSVCACCOUNT=”VIRT\sqldpm” /RSSVCPASSWORD="dpm2016+1" /AGTSVCACCOUNT=”VIRT\sqldpm” /AGTSVCPASSWORD="dpm2016+1" /SECURITYMODE=SQL /SAPWD=”dpm2016+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\\”

Please refer to the following screenshot for its output:

1. 1. Make sure that you have downloaded SQL Server Management Studio (SSMS) version 16.5.3 and that you have copied it to the server: http://go.microsoft.com/fwlink/?LinkID=840946.
   2. Open the cmd.exe window and type in the following command:

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

1. Install the DPM server:
   1. Open a command-line prompt in elevated mode and type in the following command:

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

1. 1. Once the Hyper-V role is installed, you need to restart the DPM server before you move on to the next step.
2. 1. Once the DPM server has been restarted, open Notepad, copy the following scripts into it, and then save the file as DPMSetup.ini:

[OPTIONS]
 UserName=<Domain-name\Username>
 CompanyName=<Ur-Company>
 ProductKey=XXXX-XXXX-XXXX-XXXX-XXXX
 SqlAccountPassword=<The password for the SQL sa account>
 ProgramFiles = <Location path where you want to install DPM>
 DatabaseFiles = <Location path where you want to install DPMDB>
 IntegratedInstallSource = <Location path where the DPM media is extracted>
 SQLMachineName=<Name of the SQL Server Computer> OR <SQL Cluster Name>
 SQLInstanceName=<Name of the SQL Server instance>
 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=<Name of the SQL Server instance>
 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>

1. 1. The following screenshot shows you what the DPMSetup.ini file will look like:

1. 1. After saving the DPMSetup.ini file, in an elevated command prompt on the DPM server, type in the following command and press Enter:

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

1. 1. In just a few minutes, DPM will be installed automatically, as shown in the following screenshot: