Hi,

We are trying to install SC 2012 DPM on Windows Storage Server 2008 R2 Standard. DPM is using remote SQL instance. This is a named instance, because there is also a default SQL instance running on that SQL server.

All the following links are functioning:

• Default Instance
  Web Service URL:
  http://sql01:80/ReportServer
• Report Manager URL:
  http://sql01:80/Reports

• DPM - Named Instance
  Web Service URL
  http://sql01:80/ReportServer_DPM
  https://sql01.domain.local:433/ReportServer_DPM
• Report Manager URL
  http://sql01:80/Reports_DPM
  https://sql01.domain.local:433/Report_DPM

There is an interesting fact: the Reporting Services which are used by the SQL Default Instance for the ConfigMgr requires security certificate, whereas has only HTTP protocol as listed above. At the same time DPM Named Instance does require the certificate and uses the SQL server self-signed certificate. We tried exporting it and importing it on the DPM server into the Trusted CA container, but it did not fix the issue.

We've been able to localize the error in the setup log to the following excerpt:

 [10/17/2012 4:55:59 PM] Information : Adding reports to database
 [10/17/2012 4:56:02 PM] Information : Add the machine to intranet security zone
 [10/17/2012 4:56:03 PM] * Exception :  => System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer' threw an exception. ---> System.ArgumentNullException: Key cannot be null.
 Parameter name: key
    at System.Collections.Hashtable.ContainsKey(Object key)
    at Microsoft.Internal.EnterpriseStorage.MmcContainer.ManagedFormView.GetPageController(ManagedFormView managedFormView)
    at Microsoft.Internal.EnterpriseStorage.MmcContainer.PageController.GetSingletonObject(Type objectType)
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer..ctor()
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer..cctor()
    --- End of inner exception stack trace ---
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer.get_Instance()
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.Library.Reporting.ReportingException.Translate(SoapException spEx)
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.Library.Reporting.Reporter.CreateGroupRole(String groupRoleName)
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.Library.Reporting.Reporter.ConfigureRosettaSecurity(String groupName, String groupRoleName, String serverName, String instanceName)
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
    at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args)
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ReportingConfiguration.ConfigureReporting(Boolean isRemoteDb, String rsMachineName, String rsInstanceName, String installerPath)
 [10/17/2012 4:56:03 PM] * Exception :  => Report configuration failed.Verify that SQL Server Reporting Services is installed properly and that it is running.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: exception ---> Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportDeploymentException: exception ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer' threw an exception. ---> System.ArgumentNullException: Key cannot be null.
 Parameter name: key
    at System.Collections.Hashtable.ContainsKey(Object key)
    at Microsoft.Internal.EnterpriseStorage.MmcContainer.ManagedFormView.GetPageController(ManagedFormView managedFormView)
    at Microsoft.Internal.EnterpriseStorage.MmcContainer.PageController.GetSingletonObject(Type objectType)
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer..ctor()
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer..cctor()
    --- End of inner exception stack trace ---
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer.get_Instance()
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.Library.Reporting.ReportingException.Translate(SoapException spEx)
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.Library.Reporting.Reporter.CreateGroupRole(String groupRoleName)
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.Library.Reporting.Reporter.ConfigureRosettaSecurity(String groupName, String groupRoleName, String serverName, String instanceName)
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
    at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args)
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ReportingConfiguration.ConfigureReporting(Boolean isRemoteDb, String rsMachineName, String rsInstanceName, String installerPath)
    --- End of inner exception stack trace ---
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ReportingConfiguration.ConfigureReporting(Boolean isRemoteDb, String rsMachineName, String rsInstanceName, String installerPath)
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.ConfigureReporting(String reportserverConfigFilePath, Boolean existingDB, Boolean isOemSetup, Boolean isRemoteDb, String sqlServerMachineName, String instanceName)
 *** Mojito error was: ReportDeploymentFailed; 0; None
    --- End of inner exception stack trace ---
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.ConfigureReporting(String reportserverConfigFilePath, Boolean existingDB, Boolean isOemSetup, Boolean isRemoteDb, String sqlServerMachineName, String instanceName)
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.DpmInstaller.ConfigureReporting(Boolean isRemoteDb)
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ProgressPage.InstallerThreadEntry()
 *** Mojito error was: ReportDeploymentFailed; 0; None
 [10/17/2012 4:56:03 PM] *** Error : Report configuration failed.

Verify that SQL Server Reporting Services is installed properly and that it is running.

ID: 812
 [10/17/2012 4:56:03 PM] Information : Data Protection Manager installation has failed. To return the server to its original state, you must uninstall Data Protection Manager by using Add or Remove Programs in Control Panel. This will remove all files and components copied during installation.
 For details, click the Error tab.
 [10/17/2012 4:57:43 PM] Information : <<< Dialog >>> Progress Page : Leaving
 [10/17/2012 4:57:43 PM] * Exception : Invoking Watson with Exception:  => Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: exception ---> Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.ReportDeploymentException: exception ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer' threw an exception. ---> System.ArgumentNullException: Key cannot be null.
 Parameter name: key
    at System.Collections.Hashtable.ContainsKey(Object key)
    at Microsoft.Internal.EnterpriseStorage.MmcContainer.ManagedFormView.GetPageController(ManagedFormView managedFormView)
    at Microsoft.Internal.EnterpriseStorage.MmcContainer.PageController.GetSingletonObject(Type objectType)
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer..ctor()
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer..cctor()
    --- End of inner exception stack trace ---
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.DlsServer.get_Instance()
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.Library.Reporting.ReportingException.Translate(SoapException spEx)
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.Library.Reporting.Reporter.CreateGroupRole(String groupRoleName)
    at Microsoft.Internal.EnterpriseStorage.Dls.UI.Library.Reporting.Reporter.ConfigureRosettaSecurity(String groupName, String groupRoleName, String serverName, String instanceName)
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
    at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
    at System.Type.InvokeMember(String name, BindingFlags invokeAttr, Binder binder, Object target, Object[] args)
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ReportingConfiguration.ConfigureReporting(Boolean isRemoteDb, String rsMachineName, String rsInstanceName, String installerPath)
    --- End of inner exception stack trace ---
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ReportingConfiguration.ConfigureReporting(Boolean isRemoteDb, String rsMachineName, String rsInstanceName, String installerPath)
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.ConfigureReporting(String reportserverConfigFilePath, Boolean existingDB, Boolean isOemSetup, Boolean isRemoteDb, String sqlServerMachineName, String instanceName)
 *** Mojito error was: ReportDeploymentFailed; 0; None
    --- End of inner exception stack trace ---
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.ConfigureReporting(String reportserverConfigFilePath, Boolean existingDB, Boolean isOemSetup, Boolean isRemoteDb, String sqlServerMachineName, String instanceName)
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.DpmInstaller.ConfigureReporting(Boolean isRemoteDb)
    at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ProgressPage.InstallerThreadEntry()
 *** Mojito error was: ReportDeploymentFailed; 0; None

Any suggestions on how to troubleshoot the setup failure would be highly appreciated! Thank you very much!

• Edited by VictoriaMnfd Thursday, October 18, 2012 12:59 PM

Hi Victoria

You can also look here regarding the reporting services:

http://blogs.technet.com/b/askcore/archive/2009/01/19/sql-installation-and-reporting-issues-with-data-protection-manager.aspx

and here for Ref:

http://msgroups.net/microsoft.public.dataprotectionmanager/dpm-2010-install-issue/88887

• Edited by Ed (DareDevil57)Microsoft community contributor Sunday, November 11, 2012 11:36 AM
• Marked as answer by VictoriaMnfd Tuesday, December 11, 2012 6:38 PM

On our DPM installation failure Error 812 with Reporting Services, the actual problem here was that on the remote SQL server the encryption keys had a problem. Deleting the encryption keys and then recreating new keys allowed the remote access to Reporting Services to work and DPM installtion succeeded.

Please let everyone know about this as we are not the only ones who have run into this problem.

• Proposed as answer by Sloan Venables Tuesday, November 13, 2012 5:15 AM
• Marked as answer by VictoriaMnfd Tuesday, December 11, 2012 6:38 PM

This solved one issue for me as well in the installation of DPM. Apparently my Reporting Services wasn't working out of the box. This was installed from my SCCM SQL Server 2012 SP1 Standard package.

I used the Reporting Services Configuration Manager -> Encyption Keys for deleting the keys. But when I tried deleting the keys, it generated an error that it couldn't connect to the database. So I headed to the Database tab and clicked on Change Database, Picked my existing database and used a sa account to connect. After this I clicked Change Credentials. Also here I used the SA account.

After this I was able to Delete the Encryption Keys and change them to new ones.

Please note that I had a clean installation, so carefull when deleting these keys, if you use Reporting Services for something else.

Unfortunately I received another error with ID 4323. So after running setup again to remove all data, I used this page to fix it:
https://support.microsoft.com/en-us/kb/2930276
I added an account with DOMAINNAME\MICROSOFT$DPM$Acct
Also I created another local account with the same name (according to some sites, not sure if its used)

Added this account to local administrators. Set MSSQLSERVER and SQLSERVERAGENT startup with this account. After this I ran Setup again and DPM was installed successfully.

• Edited by BerndW Friday, May 01, 2015 1:17 PM