Asked by:
dpm error

Question
-
Hello.
I'm creating a test environment to test azure as an alternative to our current backup system.
During the installation process, after server registration, I got an error with DPMWhat im doing wrong or how to handle it ?
[10/30/2019 3:26:49 AM] Information : Using WMI namespace '\\TESTSERVER\root\Microsoft\SqlServer\ReportServer\RS_SSRS\V14\admin' [10/30/2019 3:26:49 AM] Information : found instance 'SSRS' [10/30/2019 3:26:49 AM] Information : Starting Service:SQLServerReportingServices on machine:TESTSERVER flag restart:True [10/30/2019 3:26:55 AM] Information : Generating script to create new RS databases [10/30/2019 3:26:55 AM] * Exception : => DPM Setup is unable to update the report server configuration to configure e-mail settings.Log on to NO_PARAM. On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click Reporting Services Configuration. In Configure Report Server, update the e-mail settings.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportingConfigurationException: Failed to Invoke SQL Api GenerateDatabaseCreationScript at Microsoft.Internal.EnterpriseStorage.Dls.Setup.PrerequisiteInstallation.PreReportingConfiguration.InvokeMethodHelper(ManagementObject targetObject, String methodName, Dictionary`2 arguments, ManagementBaseObject& outputObject, Int32 resultToIgnore) *** Mojito error was: ReportServerConfigFailed; 0; None [10/30/2019 3:27:05 AM] * Exception : => DPM Setup is unable to update the report server configuration to configure e-mail settings.Log on to NO_PARAM. On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click Reporting Services Configuration. In Configure Report Server, update the e-mail settings.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportingConfigurationException: Failed to Invoke SQL Api GenerateDatabaseCreationScript at Microsoft.Internal.EnterpriseStorage.Dls.Setup.PrerequisiteInstallation.PreReportingConfiguration.InvokeMethodHelper(ManagementObject targetObject, String methodName, Dictionary`2 arguments, ManagementBaseObject& outputObject, Int32 resultToIgnore) *** Mojito error was: ReportServerConfigFailed; 0; None [10/30/2019 3:27:15 AM] * Exception : => DPM Setup is unable to update the report server configuration to configure e-mail settings.Log on to NO_PARAM. On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click Reporting Services Configuration. In Configure Report Server, update the e-mail settings.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportingConfigurationException: Failed to Invoke SQL Api GenerateDatabaseCreationScript at Microsoft.Internal.EnterpriseStorage.Dls.Setup.PrerequisiteInstallation.PreReportingConfiguration.InvokeMethodHelper(ManagementObject targetObject, String methodName, Dictionary`2 arguments, ManagementBaseObject& outputObject, Int32 resultToIgnore) *** Mojito error was: ReportServerConfigFailed; 0; None [10/30/2019 3:27:27 AM] * Exception : => DPM Setup is unable to update the report server configuration to configure e-mail settings.Log on to NO_PARAM. On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click Reporting Services Configuration. In Configure Report Server, update the e-mail settings.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportingConfigurationException: Failed to Execute SQL script at Microsoft.Internal.EnterpriseStorage.Dls.Setup.PrerequisiteInstallation.PreReportingConfiguration.ExecuteSqlExecuteNonQueryScriptWithRetry(String sqlInstanceName, String script) *** Mojito error was: ReportServerConfigFailed; 0; None [10/30/2019 3:27:37 AM] * Exception : => DPM Setup is unable to update the report server configuration to configure e-mail settings.Log on to NO_PARAM. On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click Reporting Services Configuration. In Configure Report Server, update the e-mail settings.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportingConfigurationException: Failed to Execute SQL script at Microsoft.Internal.EnterpriseStorage.Dls.Setup.PrerequisiteInstallation.PreReportingConfiguration.ExecuteSqlExecuteNonQueryScriptWithRetry(String sqlInstanceName, String script) *** Mojito error was: ReportServerConfigFailed; 0; None [10/30/2019 3:27:48 AM] * Exception : => DPM Setup is unable to update the report server configuration to configure e-mail settings.Log on to NO_PARAM. On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click Reporting Services Configuration. In Configure Report Server, update the e-mail settings.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportingConfigurationException: Failed to Execute SQL script at Microsoft.Internal.EnterpriseStorage.Dls.Setup.PrerequisiteInstallation.PreReportingConfiguration.ExecuteSqlExecuteNonQueryScriptWithRetry(String sqlInstanceName, String script) *** Mojito error was: ReportServerConfigFailed; 0; None [10/30/2019 3:27:58 AM] * Exception : => DPM Setup is unable to update the report server configuration to configure e-mail settings.Log on to NO_PARAM. On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click Reporting Services Configuration. In Configure Report Server, update the e-mail settings.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportingConfigurationException: Failed to Execute SQL script at Microsoft.Internal.EnterpriseStorage.Dls.Setup.PrerequisiteInstallation.PreReportingConfiguration.ExecuteSqlExecuteNonQueryScriptWithRetry(String sqlInstanceName, String script) *** Mojito error was: ReportServerConfigFailed; 0; None [10/30/2019 3:28:08 AM] * Exception : => DPM Setup is unable to update the report server configuration to configure e-mail settings.Log on to NO_PARAM. On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click Reporting Services Configuration. In Configure Report Server, update the e-mail settings.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportingConfigurationException: Failed to Execute SQL script at Microsoft.Internal.EnterpriseStorage.Dls.Setup.PrerequisiteInstallation.PreReportingConfiguration.ExecuteSqlExecuteNonQueryScriptWithRetry(String sqlInstanceName, String script) *** Mojito error was: ReportServerConfigFailed; 0; None [10/30/2019 3:28:18 AM] * Exception : => DPM Setup is unable to update the report server configuration to configure e-mail settings.Log on to NO_PARAM. On the Start menu, point to All Programs, point to Microsoft SQL Server, point to Configuration Tools, and then click Reporting Services Configuration. In Configure Report Server, update the e-mail settings.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportingConfigurationException: Failed to Execute SQL script at Microsoft.Internal.EnterpriseStorage.Dls.Setup.PrerequisiteInstallation.PreReportingConfiguration.ExecuteSqlExecuteNonQueryScriptWithRetry(String sqlInstanceName, String script) *** Mojito error was: ReportServerConfigFailed; 0; None [10/30/2019 3:28:28 AM] Information : Attempting to drop RS databases because creation failed [10/30/2019 3:28:29 AM] *** Error : CurrentDomain_UnhandledException
I added SMTP server details in RSCM but still receive the error above.
All replies
-
I hope you followed the instructions from this link - https://docs.microsoft.com/en-us/azure/backup/backup-azure-dpm-introduction
The errors you're receiving could be related to reporting services. You can refer to the troubleshooting guides - https://social.technet.microsoft.com/wiki/contents/articles/53080.dpm-2019-troubleshooting-installation-error-failed-to-perform-the-check.aspx and https://support.microsoft.com/en-in/help/4457489/reporting-services-server-cannot-connect-to-the-dpm-database-when-you might help fix this issue.
- Proposed as answer by SadiqhAhmed-MSFTMicrosoft employee, Moderator Friday, November 1, 2019 7:40 AM