none
DPM 2012 Install Fails, The Database was not Created ID 811 RRS feed

  • Question

  • Hi.

    I've tried installing DPM on a Standalone Server (SQL + DPM), and get the "Database was not Created" error. I initially tried DPM 2012 R2, and found that there is an issue with Disjoint Namespaces, so went to DPM 2012 SP1, but still getting the same error.

    The Install Account has full access rights (sysadmin) to the DPM SQL Instance, however cannot seem to get it right. The account using to do the install has full Enterprise admin, Domain Admin, Backup Operators & Administrators rights.

    When opeining SQL Managemet studio, I can see the database has been created but the setup fails and requires me to revert.Here is the last few lines of the Install Log File, please help I always mark as answer.

    2014-10-01 08:54:49 PM] Information : Configuration.DBConfigurator: Setting Read_Committed_SnapShot ON
    [2014-10-01 08:54:49 PM] Information : Creating tables
    [2014-10-01 08:54:49 PM] Information : Execute the SQL script
    [2014-10-01 08:54:49 PM] Data : FileName = "D:\Program Files\Microsoft System Center 2012\DPM\SQL\100\Tools\Binn\SQLCMD.EXE"
    [2014-10-01 08:54:49 PM] Data : Arguments = -b -E -d DPMDB_S_PRODBACKUP -i MiniSetupDBConfiguration.sql -r -S S-PRODBACKUP\SCDPM
    [2014-10-01 08:54:49 PM] Data : Error code = 0
    [2014-10-01 08:54:49 PM] Information : Adding DPM Server entry in tbl_AM_Server table
    [2014-10-01 08:54:49 PM] Information : Preloading Microsoft.Internal.EnterpriseStorage.Dls.AgentManager.DB.InstalledAgents
    [2014-10-01 08:54:49 PM] Information : Preloading Microsoft.Internal.EnterpriseStorage.Dls.EngineUICommon.DpmThreadPool
    [2014-10-01 08:54:50 PM] Data : Database connection string = Integrated Security=SSPI;server=S-PRODBACKUP\SCDPM;Pooling=false;database=DPMDB_S_PRODBACKUP;Pooling=false
    [2014-10-01 08:54:50 PM] Information : Grant execute permissions on dbo.prc_MOM_ProductionServer_Get to DPMDBReaders$S-PRODBACKUP
    [2014-10-01 08:54:50 PM] Information : Grant execute permissions on dbo.prc_MOM_HeartBeat_Get to DPMDBReaders$S-PRODBACKUP
    [2014-10-01 08:54:50 PM] Information : Configuration.DBConfigurator: Registering DPM category
    [2014-10-01 08:54:50 PM] Information : Configuration.DBConfigurator: Adding DPM Category to GlobalSettings table
    [2014-10-01 08:54:50 PM] Information : Configuration.DBConfigurator: Adding ConsiderOfflineMediaToCheckOffsiteReady to GlobalSettings table
    [2014-10-01 08:54:50 PM] Information : Add job definitions
    [2014-10-01 08:54:52 PM] Information : Creating schedules
    [2014-10-01 08:55:00 PM] * Exception :  => System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
       at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
       at Microsoft.Internal.EnterpriseStorage.Dls.Engine.CProxyUtils.HandleErrors(Int32 hr, tagSAFEARRAY* exceptionResult)
       at Microsoft.Internal.EnterpriseStorage.Dls.Engine.SchedulerServicesProxy.Register(String scheduleXml)
       --- 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 Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.RegisterScheduleXml(String scheduleXml)
    [2014-10-01 08:55:00 PM] * Exception :  => The DPM database was not created.Use Add or Remove Programs in Control Panel to remove the DPM files and registry entries that were created during Setup. Verify that SQL Server is properly installed and that it is running, and then run Setup again.Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.BackEndErrorException: exception ---> Microsoft.Internal.EnterpriseStorage.Dls.Setup.Exceptions.DatabaseConfigurationException: exception ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Runtime.InteropServices.COMException (0x800706BE): The remote procedure call failed. (Exception from HRESULT: 0x800706BE)
       at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
       at Microsoft.Internal.EnterpriseStorage.Dls.Engine.CProxyUtils.HandleErrors(Int32 hr, tagSAFEARRAY* exceptionResult)
       at Microsoft.Internal.EnterpriseStorage.Dls.Engine.SchedulerServicesProxy.Register(String scheduleXml)
       --- 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 Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.RegisterScheduleXml(String scheduleXml)
       --- End of inner exception stack trace ---
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.RegisterScheduleXml(String scheduleXml)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.RegisterSchedule(String scheduleXmlFile)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.PopulateDefaultScheduleDefinitionsInDatabase(DBConfigurationReader dbCfgReader)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Configuration.DBConfigurator.AddJobAndScheduleDefinitions()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.MiniSetupConfiguration.PopulateDB(Boolean upgrading, Boolean isRemoteDb, String sqlServerMachineName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.MachineSpecificConfiguration(Boolean existingDB, Boolean upgrading, Boolean isRemoteDb, String sqlServerMachineName, String instanceName)
    *** Mojito error was: DatabaseCreateFailed; 0; None
       --- End of inner exception stack trace ---
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.MachineSpecificConfiguration(Boolean existingDB, Boolean upgrading, Boolean isRemoteDb, String sqlServerMachineName, String instanceName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.BackEnd.Configure(Boolean existingDB, Boolean upgrading, String databaseLocation, String sqlServerMachineName, String instanceName, Boolean oemSetup)
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.DpmInstaller.Configure()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ProgressPage.InstallDpm()
       at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Wizard.ProgressPage.InstallerThreadEntry()
    *** Mojito error was: DatabaseCreateFailed; 0; None
    [2014-10-01 08:55:02 PM] *** Error : The DPM database was not created.

    Use Add or Remove Programs in Control Panel to remove the DPM files and registry entries that were created during Setup. Verify that SQL Server is properly installed and that it is running, and then run Setup again.

    ID: 811
    [2014-10-01 08:55:02 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.
    [2014-10-01 09:33:51 PM] Data : Error Code Web Link = http://go.microsoft.com/fwlink/events.asp?ProdName=Microsoft System Center Data Protection Manager&ProdVer=4.1.3313.0&EvtID=811&EvtSrc=MSDPM&LCID=1033&P2wAppId=p2wMsdpmEE

    Wednesday, October 1, 2014 7:51 PM

Answers

  • The Dedicated install worked. Not sure what the difference was between pre-installed SQL on the Same Server or SQL Instance installed with the DPM Server.

    Anyways, just glad it works.

    • Marked as answer by krokebob Saturday, October 18, 2014 9:23 AM
    Saturday, October 18, 2014 9:23 AM

All replies

  • have you extracted your ISO?

    please download a new ISO and Mount, no extracting.

    Got the same, and figured out that my Image and Extraction has an Error


    Seidl Michael | http://www.techguy.at | twitter.com/techguyat | facebook.com/techguyat

    Thursday, October 2, 2014 9:03 AM
  • Hi Michael.

    First of all thank you for your reply. I have now re-downloaded the ISO and directly mounted it with similar results.

    The .ISO I originally used (both the 2012 SP1 and 2012 R2 versions) have been working at other installations on different domains without any issues.

    Do you have any other ideas?

    Thursday, October 2, 2014 5:07 PM
  • Anyone have any information on this? I am very desperate for an answer.
    Wednesday, October 8, 2014 5:09 AM
  • Hi,

    Check the SQL Agent account on the remote SQL server and make sure the user account syntax is in the form of UserName\DomainName and not UserName@DomainName - if it is change it.


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.


    Monday, October 13, 2014 6:15 PM
    Moderator
  • Hi Mike.

    I did check this, and the Agent was in the form DOMAIN.LOCAL\SQLSERVERSERVICEACCOUNT

    Friday, October 17, 2014 7:52 AM
  • I am now trying an Installation, where I will use the dedicated instance of SQL Server installed by DPM itself to see if it makes any difference.

    Will update the forum on my progress.

    Friday, October 17, 2014 7:59 AM
  • The Dedicated install worked. Not sure what the difference was between pre-installed SQL on the Same Server or SQL Instance installed with the DPM Server.

    Anyways, just glad it works.

    • Marked as answer by krokebob Saturday, October 18, 2014 9:23 AM
    Saturday, October 18, 2014 9:23 AM