none
dpm error RRS feed

  • 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 DPM 

    What 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. 

    Wednesday, October 30, 2019 10:48 AM

All replies