none
SC 2012 DPM - How to Create DPMReport (DPMR$<DPM_Server>) Local Account Manually RRS feed

  • Question

  • Hello!

    The installation of the DPM 2012 was unable to create DPMR$<DMP_Server> account which is used by the Reporting Services of the DPM.

    Is there a way how to recreate that account and assign proper permissions in case if it has not been created or has been deleted accidently?

    Many thanks in advance!


    Monday, October 22, 2012 2:01 PM

Answers

  • hmmmm, does the DPM machine have any GPO's applied to it? Have you tried adding the Domain account that you installing SQL and DPM with to the local machine administrators group? 
    • Marked as answer by VictoriaMnfd Tuesday, December 11, 2012 6:39 PM
    Thursday, October 25, 2012 5:20 AM

All replies

  • Hi VictoriaMnfd

    What was the error message you got when it couldnt create that account? DPM creates it when you do the installation.

    Is this a new installation? That account is used for securely generating reports. Is SQL up and running on your machine?

    Kind Regards

    DareDevil57

    Monday, October 22, 2012 4:29 PM
  • Hi DareDevil57!

    Thank you very much for your time and attention!

    Verbatim error message is the following:

    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.
    DPM Setup has not configured Reporting Services to use Secure Sockets Layer. For more information on how to configure the Report Server for Secure Sockets Layer (SSL) connections, see Configuring Report Server for Secure Sockets Layer (http://go.microsoft.com/fwlink/?LinkId=178289)
    Report configuration failed.
    Verify that SQL Server Reporting Services is installed properly and that it is running.
    ID: 812
    http://technet.microsoft.com/en-us/library/ms345223(SQL.105).aspx
    Error ID 812 — Data Protection Manager

    This is a new installation. This installation has never been installed successfully (Reporting Services failed to install), but we are able to use the rest of the DPM functionality through. Even with error related to the Reporting Services all other DPM components: Monitoring, Protection, Recovery and Management are working fine. We tried using the remote instance of SQL and the local instance - still the same issue. We ended up installing using the local instance. However, we are using named instance DPM, not a default one.

    • SQL Server (DPM), SQL Server Reporting Services (DPM), SQL Server Agent (DPM), SQL Server Browser - Automatic, Running.
    • SQL Full-Text Filter Daemon Launcher (DPM) - Manula, Running.
    • SQL Native Client 10.0 Configuration 32 bit and 64 bit: Client Protocols - TCP/IP, Named Pipes, Shared Memeory - Enabled
    • SQL Native Server Network Configuration / Protocols for DPM: Shared Memory and TCP/IP - Enabled. (For the remote instance we also had Named Pipes enabled).
    • SQL instance used domain service account. This account is in the Administrators group of the DPM server and SQL server (for the case of the remote instance).
    • The password for the local DPMReport account was complex.
    • Similar deployment worked fine in test virtual environment.

    As for the Reporting Services, the following folders are browsable and are populated with sub-folders which are related to the DPM Reporting Services:

    • http :// DPMServer/ReportServer_DPM
    • http :// DPMServer/Reports_DPM/Pages/Folder.aspx

    [To Parent Directory]

    295115 DiskUtilization
    <link> DiskUtilizationReport
      <ds> DPMReporterDataSource
    12043 DPMReportsLogo_2012.png
    144070 MediaDetails
    <link> MediaDetailsReport
    142391 Recovery
     85372 RecoveryPointStatus
    <link> RecoveryPointStatusReport
    <link> RecoveryReport
    214152 Status
    <link> StatusReport
    148404 TapeUtilization
    <link> TapeUtilizationReport

    Here is an excerpt from the DPM installation log. The error is in bold text.

    [10/18/2012 11:47:06 AM] Information : Configure reporting.
    [10/18/2012 11:47:06 AM] Data : Path of configuration file of SQL Server Reporting Services = \\DPMServer03\C$\Program Files\Microsoft SQL Server\MSRS10_50.DPM\Reporting Services\ReportServer\RSReportServer.config
    [10/18/2012 11:47:06 AM] Data : SMTP server address for notification = 
    [10/18/2012 11:47:06 AM] * Exception : Ignoring the following exception intentionally => System.Data.SqlClient.SqlException: Cannot drop the user 'DOMAIN\DPMSERVER$', because it does not exist or you do not have permission.
       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
       at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
       at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
       at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
       at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.DB.SqlRetryCommand.ExecuteNonQuery()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Helpers.SetupDatabaseHelper.RevokeDatabaseAccess(SqlContext ctx, String nameInDatabase)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Helpers.SetupDatabaseHelper.GrantDatabaseAccess(SqlContext ctx, String loginName, String nameInDatabase)
    [10/18/2012 11:47:06 AM] Information : Configure reporting.
    [10/18/2012 11:47:06 AM] Data : Source folder for reports (.rdl files) = C:\Users\sqladmin\AppData\Local\Temp\DPMF8CF.tmp\DPM2012\Setup\DpmReports
    [10/18/2012 11:47:06 AM] Data : Path of dll to invoke = C:\Users\sqladmin\AppData\Local\Temp\DPMF8CF.tmp\DPM2012\Setup\DlsUILibrary.dll
    [10/18/2012 11:47:06 AM] Information : Adding reports to database
    [10/18/2012 11:47:07 AM] Information : Add the machine to intranet security zone
    [10/18/2012 11:47:07 AM] * 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/18/2012 11:47:07 AM] * 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/18/2012 11:47:08 AM] *** Error : Report configuration failed.

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

    ID: 812
    [10/18/2012 11:47:08 AM] 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/18/2012 11:48:14 AM] Information : <<< Dialog >>> Progress Page : Leaving
    [10/18/2012 11:48:14 AM] * 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

    And this is how it's supposed to be in the log:

    [10/18/2012 11:47:07 AM] Information : Add the machine to intranet security zone
    [10/18/2012 11:47:07 AM] Information : Create and set passwored for Reporting account:DpmReport
    [10/18/2012 11:47:07 AM] Information : End configuration.

    Thank you very much for your help in advance!

    Monday, October 22, 2012 7:13 PM
  • Hi VictoriaMnfd

    Sorry for the late reply :-)

    Just a question, you say the installation never finished successfully? How many time have you tried to install DPM?

    Wednesday, October 24, 2012 6:51 AM
  • Absolutely not a problem, DareDevil57! :)

    We tried installing it several times using the remote instance as well as local instance.

    Also, there is a SCCM 2012 in the environment which has Reporting Services malfunctioning. But everything except the Reporting Services for DPM (and SCCM) works fine.

    Wednesday, October 24, 2012 4:31 PM
  • hmmmm, does the DPM machine have any GPO's applied to it? Have you tried adding the Domain account that you installing SQL and DPM with to the local machine administrators group? 
    • Marked as answer by VictoriaMnfd Tuesday, December 11, 2012 6:39 PM
    Thursday, October 25, 2012 5:20 AM