This is yet another blog post about System Center installation errors, today we’ll be talking about installation errors during the DPM 2019 installation.
Introduction
DPM doesn’t have many prerequisites, even the SQL Server only requires two (2) features, Database Engine Services and Reporting Services, which makes the installation of DPM pretty easy, or does it?
During a few quick lab setups, I’ve encountered a few issues when trying to install DPM 2019, I’ve also noticed these exact same issues coming up in the Microsoft community, so I decided to go through these in this blog post.
DPM 2019 prerequisites
- .NET Framework 4.0 or 4.5 (for DPM 2016 / 2019).
- .NET Framework 3.5 required for SQL installation (before SQL 2016).
- .NET Framework 4.6 required for SQL installation (SQL 2016 onwards).
- Windows Installer 4.5 (or later).
- Microsoft Visual C++ 2012 Redistributable.
- Microsoft Visual C++ 2010 Redistributable.
- Microsoft Visual C++ 2008 Redistributable.
- PowerShell 3.0 (included with Windows Server 2012 R2 or 2012).
These prequisites can also be found from the Microsoft official documentation over here: Setup prerequisites
SQL Server prerequisites
Features:
- Database Engine Services
- Reporting Services (for DPM 2019, install SSRS with SQL 2017)
Collation:
- SQL_Latin1_General_CP1_CI_AS
These prerequisites can also be found from the Microsoft official documentation over here: SQL Server database
Installing DPM 2019
We have successfully installed all the prerequisites for both DPM and the SQL Server, and when we run the DPM installation we still receive errors during the prerequisites check, we will go through this more in detail below.
Below are the steps we’ve done:
1. Right-click the Setup.exe from the extracted the DPM installation media, and choose Run as administrator.
2. In the System Center 2019 Data Protection Manager setup screen, click on Data Protection Manager under the Install section.
3. A Microsoft Software License Terms window will appear, click Accept.
4. The Data Protection Manager Setup wizard will appear, click Next to continue.
5. Select either the stand-alone or clustered SQL Server option, depending on what we have, in our example we use a stand-alone SQL Server, enter the SQL Server name and the DPM instance name, then click Check and Install.
6. We now receive three (3) different errors:
-
The SQLServerReportingServices service is running under NT SERVICE\SQLServerReportingServices credentials. We recommend that the service run under the NT Authority\NETWORK SERVICE account.In the Reporting Services Configuration tool, choose ‘Service account’, and then change the settings to the built-in Network Service account for SSRS instance of SQL Server.
-
The missing prerequisite (HyperVPowerShell) has been installed.Restart the computer and run the application again.
-
Failed to perform the check.See the log file for details and try again.
The HyperVPowerShell has been automatically installed by DPM, so all we need to do is to restart the computer and this error will be gone.
Changing the SQL Reporting Services service account
1. Open the Report Server Configuration Manager.
2. Connect to our DPM Report Server instance by clicking Connect.
3. Head to the Service Account tab which can be found on the upper left.
4. As we can see, by default when you install SQL Reporting Services it will run on a “virtual service account“, to change this check the Use another account check box and fill in the account name and password of the domain account that we want to use to run the Report Server service account, then click Apply.
5. Once the new service account has been applied, we should see that the task has been successfully completed under the Results section.
We have now done the following:
- Changed the SQL Server Reporting Services service account to a domain service account.
- Restarted the DPM computer.
The Problem
We have successfully installed all the prerequisites for both DPM and the SQL Server, Let’s try to run the DPM 2019 installation again, follow step 1-5 in the Installing DPM 2019 section.
We now only receive one (1) error:
This error doesn’t provide any details, so we will need to check the DpmSetup.log file for more information about this error.
Open the DpmSetup.log which can be found under:
- C:\Program Files\Microsoft System Center\DPM\DPMLogs
Scroll down the log and search for errors, what we can find is the following:
[2019-06-10 11:57:46] *** Error : Can not access properties of the WMI class. [2019-06-10 11:57:46] * Exception : Failed to perform the check => System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportingConfigurationAccessException: Can not access properties of Reporting configuration class at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectHelper.GetReportServerVirtualDirectoryName(String reportServerMachineName, String reportServerInstanceName, ConnectionOptions wmiConnectionOptions, String ReportingNameSpace) at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectHelper.CheckIfReportServerURLIsAccessible(String reportingMachineName, String reportingInstanceName, ConnectionOptions connOptions, String reportingNamespace) at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectPrerequisites.CheckIfReportServerURLIsAccessible(InspectContext context) --- End of inner exception stack trace --- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.Inspect.RunCheck(String checkId)
We can clearly see that there’s something wrong with our SQL Server Reporting Services.
The Solution
We need to verify that the below steps have been done:
- SQL Server Reporting Services service is up and running.
- SQL Server Reporting Services database is configured.
- SQL Server Reporting Services Web Service URL is configured.
- SQL Server Reporting Services Web Portal URL is configured.
Checking the SQL Reporting Service status
As we can see, the Report Server service is running and has the status Started, so all is good on that part.
SQL Reporting Service database status
The database has empty fields, this means that we have not configured a Report server database, this is one thing that must be done.
Configuring the SQL Server Reporting database
1. In the Report Server Configuration Manager, head to the Database tab which can be found on the left. Then click on Change Database.
2. A Report Server Database Configuration Wizard will appear, select Create a new report server database (Or Choose an existing report server database if you already have one installed somewhere) and then click Next.
3. Enter the server name and instance name of the DPM SQL instance, then click Test Connection.
4. Once the connection has been tested successfully click OK and on Next to continue.
5. Enter a database name for our Report server or use the default name, then click Next.
6. Specify the credentials that the configuration wizard will use to connect to the Report Server database, then click Next.
7. Click Next to start configuring the Report Server database.
8. Once the Report Server database has been configured, click on Finish.
9. We should now have the Report Server database configured and running.
Configuring the Reporting Web Service URL
1. Head to the Web Service URL tab on the left-hand side of the Report Server Configuration Manager.
2. As we can see, we have a warning at the top saying that the Report Server Web Service is not configured:
3. To configure it, simply click on Apply.
4. Once the Web Service URL has been configured, we should see the task being successful under the Results section.
Configuring the Reporting Web Portal URL
1. Head to the Web Portal URL tab on the left-hand side of the Report Server Configuration Manager.
2. As we can see, we have a warning at the top saying that the Report Server Web Portal is not configured:
3. Click on Apply to configure the Web Portal.
4. Once the Web Portal URL has been configured, we should see the task being successful under the Results section.
We should now have the SQL Server Reporting Services fully configured, let’s try running the DPM 2019 installer one last time, follow step 1-5 in the Installing DPM 2019 section.
We should now receive the following message:
“This computer meets the software and hardware requirements for DPM”
We can now continue with our DPM 2019 installation!
Yes. The reason of installation stuck was Reporting Server (spec. not configured)
Thanks from Russia 🙂
LikeLike
Thank you for the excellent article! I just installed SQL 2017 in preparation for DPM 2019 install, and this helped me avoid all the pitfalls.
LikeLike
Just one more task when configuring Reporting Server. You have to delete encrypted content!
LikeLike
Hi,
There should be no need for that during a new installation, unless you are using an existing Reporting Server.
Best regards,
Leon
LikeLike
The installation of SQL server is always before the DPM, so the server is existing.
LikeLike
I’ve never needed to delete the encrypted content.
LikeLike
I had this great opportunity 4 times.
LikeLike
It’s most likely due to something else, it’s difficult to say as I don’t know the process you have taken to install SQL Server & SQL Reporting Services.
A simple and clean installation of SQL Server, SQL Server Reporting Services & DPM 2019 will not require you to delete the encrypted data.
Try it in a test environment and you’ll see 🙂
LikeLike
I am talking about SQL 2016 standard installation and the problem appears every time. Sorry to say but SQL reporting sometime even do not works as expected. Next time will try with 2017 may be it is better. Will see this.
Thanks for your time and efforts.
BR
Christo
LikeLike
Thank you
LikeLike
OUTSTANDING Article. This walked me through the issue I was having perfectly.
LikeLike
will the DPM 2019 deployment works on SQL 2019. Currently we are in process of upgrading the DPM2016 + SQL 2012 to DPM2019 with SQL2019. Can this be doable as most of the prerequisite say only SQL 2017 with DPM 2019.
LikeLike
Hi,
As of today DPM 2019 is not yet supported for SQL Server 2019.
Support for SQL Server 2019 will most likely come later on.
Best regards,
Leon
LikeLike
Awesome have my DPM up and running, This was to the point on the errors i was having.
LikeLike
hello. it seems as if i am almost there on getting my first dpm box online, but im running into the following “Got Error Message: SQL Server Management Tools are not installed on this machine.Please install SQL Tools compatible with the installed SQL Server version.”
my sql is a single remote box running sql 2017. i installed the latest version of ssrs however this did not help. i then have downgraded the vrs of ssrs a couple of times, but still i receive the “sql server mgmt tools not installed”.
as of now, my sql has the db engine services, full text search, and ssrs. can u think of any other sql mgmt tools i might be missing? is it possibly and issue with having sql server 2017 installed and me not having the right ssrs vrs that i need to be installing?
LikeLike
Hi,
DPM 2019 is very sensitive about the version of the SQL Server Management Studio, you’ll need specifically version 17.9.1, make sure you install it on the DPM server.
https://go.microsoft.com/fwlink/?linkid=2043154&clcid=0x409
Best regards,
Leon
LikeLike
indeed it is!!! ok so ssms 17.9.1 on the sql box as well as the dpm host box. i’ll give it a go. really apprecaite the fast reply!!!
LikeLike
hello. wanted to pick ur brain on a new setup error im receiving. im getting “DPM configuration failed 4081” and all i can see in the log is the following “*** Mojito error was: ConfigurationFailed; 1722; WindowsAPI”
i can connect to my stand along remote sql over 1433 with ssms so i know thats not the issue. a netmon also shows several Acks so i think the networking is fine. ive had success with other setups but this one i cant get past.
any ideas would be awesome. and per my previous ask the ssms 17.9.1 did work like a champ so much appreciation on that!
LikeLike
i got it….it was WMI. had to add the WMI ports and high ephemeral and were in! thanks again!
LikeLike