none
DPM 2010 crashes RRS feed

  • Question

  • Hi!

    I use DPM 2010.

    A lot of time - for example when I try modify protection group - MMC crashes with error (in Application Event Log)

     

    Log Name:      Application
    Source:        MSDPM
    Date:          8/8/2011 1:58:00 PM
    Event ID:      945
    Task Category: None
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      SERVER.DOMAIN
    Description:
    The description for Event ID 945 from source MSDPM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    If the event originated on another computer, the display information had to be saved with the event.

    The following information was included with the event:

    Unable to connect to the DPM database because of a general database failure.  Make sure that SQL Server is running and that it is configured correctly.

    Problem Details:
    <FatalServiceError><__System><ID>19</ID><Seq>49</Seq><TimeCreated>8/8/2011 11:58:00 AM</TimeCreated><Source>DpmThreadPool.cs</Source><Line>163</Line><HasError>True</HasError></__System><ExceptionType>SqlException</ExceptionType><ExceptionMessage>Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
    The statement has been terminated.</ExceptionMessage><ExceptionDetails>System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
       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.Scheduler.SqlAgentHelper.AddJob(String jobName, String jobOwner, String categoryName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Scheduler.SqlAgentHelper.RegisterSchedule(Schedule schedule)
       at Microsoft.Internal.EnterpriseStorage.Dls.Scheduler.RegisterScheduleHelper.PerformDBOperation()
       at Microsoft.Internal.EnterpriseStorage.Dls.Scheduler.RegisterScheduleHelper.Execute(SqlContext sqlContext)
       at Microsoft.Internal.EnterpriseStorage.Dls.Scheduler.CommandHelper.Execute()
       at Microsoft.Internal.EnterpriseStorage.Dls.Scheduler.SchedulerImpl.Register(SqlContext sqlContext, String scheduleXml)
       at Microsoft.Internal.EnterpriseStorage.Dls.AgentManager.ConnectivityJobCreator.RecreateJob()
       at Microsoft.Internal.EnterpriseStorage.Dls.AgentManager.ConnectivityJobCreator.RecreateConnectivityRefreshJob()
       at Microsoft.Internal.EnterpriseStorage.Dls.AgentManager.ACUninstallMachine.CleanUp(Message msg)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.Fsm.Transition.Execute(Message msg)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.Fsm.Engine.ChangeState(Message msg)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.TaskInstance.Process(Object dummy)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.FsmThreadFunction.Function(Object taskThreadContextObj)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
       at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)</ExceptionDetails></FatalServiceError>


    the message resource is present but the message is not found in the string/message table

    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
      <System>
        <Provider Name="MSDPM" />
        <EventID Qualifiers="0">945</EventID>
        <Level>2</Level>
        <Task>0</Task>
        <Keywords>0x80000000000000</Keywords>
        <TimeCreated SystemTime="2011-08-08T11:58:00.000000000Z" />
        <EventRecordID>5761</EventRecordID>
        <Channel>Application</Channel>
        <Computer>SERVER.DOMAIN</Computer>
        <Security />
      </System>
      <EventData>
        <Data>Unable to connect to the DPM database because of a general database failure.  Make sure that SQL Server is running and that it is configured correctly.

    Problem Details:
    &lt;FatalServiceError&gt;&lt;__System&gt;&lt;ID&gt;19&lt;/ID&gt;&lt;Seq&gt;49&lt;/Seq&gt;&lt;TimeCreated&gt;8/8/2011 11:58:00 AM&lt;/TimeCreated&gt;&lt;Source&gt;DpmThreadPool.cs&lt;/Source&gt;&lt;Line&gt;163&lt;/Line&gt;&lt;HasError&gt;True&lt;/HasError&gt;&lt;/__System&gt;&lt;ExceptionType&gt;SqlException&lt;/ExceptionType&gt;&lt;ExceptionMessage&gt;Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
    The statement has been terminated.&lt;/ExceptionMessage&gt;&lt;ExceptionDetails&gt;System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
    The statement has been terminated.
       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.Scheduler.SqlAgentHelper.AddJob(String jobName, String jobOwner, String categoryName)
       at Microsoft.Internal.EnterpriseStorage.Dls.Scheduler.SqlAgentHelper.RegisterSchedule(Schedule schedule)
       at Microsoft.Internal.EnterpriseStorage.Dls.Scheduler.RegisterScheduleHelper.PerformDBOperation()
       at Microsoft.Internal.EnterpriseStorage.Dls.Scheduler.RegisterScheduleHelper.Execute(SqlContext sqlContext)
       at Microsoft.Internal.EnterpriseStorage.Dls.Scheduler.CommandHelper.Execute()
       at Microsoft.Internal.EnterpriseStorage.Dls.Scheduler.SchedulerImpl.Register(SqlContext sqlContext, String scheduleXml)
       at Microsoft.Internal.EnterpriseStorage.Dls.AgentManager.ConnectivityJobCreator.RecreateJob()
       at Microsoft.Internal.EnterpriseStorage.Dls.AgentManager.ConnectivityJobCreator.RecreateConnectivityRefreshJob()
       at Microsoft.Internal.EnterpriseStorage.Dls.AgentManager.ACUninstallMachine.CleanUp(Message msg)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.Fsm.Transition.Execute(Message msg)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.Fsm.Engine.ChangeState(Message msg)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.TaskInstance.Process(Object dummy)
       at Microsoft.Internal.EnterpriseStorage.Dls.TaskExecutor.FsmThreadFunction.Function(Object taskThreadContextObj)
       at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
       at System.Threading._ThreadPoolWaitCallback.PerformWaitCallbackInternal(_ThreadPoolWaitCallback tpWaitCallBack)
       at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)&lt;/ExceptionDetails&gt;&lt;/FatalServiceError&gt;
    </Data>
        <Binary>3C0046006100740061006C0053006500720076006900630065004500720072006F0072003E003C005F005F00530079007300740065006D003E003C00490044003E00310039003C002F00490044003E003C005300650071003E00340039003C002F005300650071003E003C00540069006D00650043007200650061007400650064003E0038002F0038002F0032003000310031002000310031003A00350038003A0030003000200041004D003C002F00540069006D00650043007200650061007400650064003E003C0053006F0075007200630065003E00440070006D0054006800720065006100640050006F006F006C002E00630073003C002F0053006F0075007200630065003E003C004C0069006E0065003E003100360033003C002F004C0069006E0065003E003C004800610073004500720072006F0072003E0054007200750065003C002F004800610073004500720072006F0072003E003C002F005F005F00530079007300740065006D003E003C0045007800630065007000740069006F006E0054007900700065003E00530071006C0045007800630065007000740069006F006E003C002F0045007800630065007000740069006F006E0054007900700065003E003C0045007800630065007000740069006F006E004D006500730073006100670065003E00430061006E006E006F007400200069006E00730065007200740020007400680065002000760061006C007500650020004E0055004C004C00200069006E0074006F00200063006F006C0075006D006E00200027006F0077006E00650072005F0073006900640027002C0020007400610062006C006500200027006D007300640062002E00640062006F002E007300790073006A006F006200730027003B00200063006F006C0075006D006E00200064006F006500730020006E006F007400200061006C006C006F00770020006E0075006C006C0073002E00200049004E00530045005200540020006600610069006C0073002E000D000A005400680065002000730074006100740065006D0065006E007400200068006100730020006200650065006E0020007400650072006D0069006E0061007400650064002E003C002F0045007800630065007000740069006F006E004D006500730073006100670065003E003C0045007800630065007000740069006F006E00440065007400610069006C0073003E00530079007300740065006D002E0044006100740061002E00530071006C0043006C00690065006E0074002E00530071006C0045007800630065007000740069006F006E003A002000430061006E006E006F007400200069006E00730065007200740020007400680065002000760061006C007500650020004E0055004C004C00200069006E0074006F00200063006F006C0075006D006E00200027006F0077006E00650072005F0073006900640027002C0020007400610062006C006500200027006D007300640062002E00640062006F002E007300790073006A006F006200730027003B00200063006F006C0075006D006E00200064006F006500730020006E006F007400200061006C006C006F00770020006E0075006C006C0073002E00200049004E00530045005200540020006600610069006C0073002E000D000A005400680065002000730074006100740065006D0065006E007400200068006100730020006200650065006E0020007400650072006D0069006E0061007400650064002E000D000A00200020002000610074002000530079007300740065006D002E0044006100740061002E00530071006C0043006C00690065006E0074002E00530071006C0043006F006E006E0065006300740069006F006E002E004F006E004500720072006F0072002800530071006C0045007800630065007000740069006F006E00200065007800630065007000740069006F006E002C00200042006F006F006C00650061006E00200062007200650061006B0043006F006E006E0065006300740069006F006E0029000D000A00200020002000610074002000530079007300740065006D002E0044006100740061002E00530071006C0043006C00690065006E0074002E005400640073005000610072007300650072002E005400680072006F00770045007800630065007000740069006F006E0041006E0064005700610072006E0069006E0067002800540064007300500061007200730065007200530074006100740065004F0062006A006500630074002000730074006100740065004F0062006A0029000D000A00200020002000610074002000530079007300740065006D002E0044006100740061002E00530071006C0043006C00690065006E0074002E005400640073005000610072007300650072002E00520075006E002800520075006E004200650068006100760069006F0072002000720075006E004200650068006100760069006F0072002C002000530071006C0043006F006D006D0061006E006400200063006D006400480061006E0064006C00650072002C002000530071006C00440061007400610052006500610064006500720020006400610074006100530074007200650061006D002C002000420075006C006B0043006F0070007900530069006D0070006C00650052006500730075006C0074005300650074002000620075006C006B0043006F0070007900480061006E0064006C00650072002C002000540064007300500061007200730065007200530074006100740065004F0062006A006500630074002000730074006100740065004F0062006A0029000D000A00200020002000610074002000530079007300740065006D002E0044006100740061002E00530071006C0043006C00690065006E0074002E00530071006C0043006F006D006D0061006E0064002E00460069006E0069007300680045007800650063007500740065005200650061006400650072002800530071006C0044006100740061005200650061006400650072002000640073002C002000520075006E004200650068006100760069006F0072002000720075006E004200650068006100760069006F0072002C00200053007400720069006E0067002000720065007300650074004F007000740069006F006E00730053007400720069006E00670029000D000A00200020002000610074002000530079007300740065006D002E0044006100740061002E00530071006C0043006C00690065006E0074002E00530071006C0043006F006D006D0061006E0064002E00520075006E004500780065006300750074006500520065006100640065007200540064007300280043006F006D006D0061006E0064004200650068006100760069006F007200200063006D0064004200650068006100760069006F0072002C002000520075006E004200650068006100760069006F0072002000720075006E004200650068006100760069006F0072002C00200042006F006F006C00650061006E002000720065007400750072006E00530074007200650061006D002C00200042006F006F006C00650061006E0020006100730079006E00630029000D000A00200020002000610074002000530079007300740065006D002E0044006100740061002E00530071006C0043006C00690065006E0074002E00530071006C0043006F006D006D0061006E0064002E00520075006E004500780065006300750074006500520065006100640065007200280043006F006D006D0061006E0064004200650068006100760069006F007200200063006D0064004200650068006100760069006F0072002C002000520075006E004200650068006100760069006F0072002000720075006E004200650068006100760069006F0072002C00200042006F006F006C00650061006E002000720065007400750072006E00530074007200650061006D002C00200053007400720069006E00670020006D006500740068006F0064002C002000440062004100730079006E00630052006500730075006C007400200072006500730075006C00740029000D000A00200020002000610074002000530079007300740065006D002E0044006100740061002E00530071006C0043006C00690065006E0074002E00530071006C0043006F006D006D0061006E0064002E0049006E007400650072006E0061006C0045007800650063007500740065004E006F006E00510075006500720079002800440062004100730079006E00630052006500730075006C007400200072006500730075006C0074002C00200053007400720069006E00670020006D006500740068006F0064004E0061006D0065002C00200042006F006F006C00650061006E002000730065006E00640054006F00500069007000650029000D000A00200020002000610074002000530079007300740065006D002E0044006100740061002E00530071006C0043006C00690065006E0074002E00530071006C0043006F006D006D0061006E0064002E0045007800650063007500740065004E006F006E0051007500650072007900280029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E00440042002E00530071006C005200650074007200790043006F006D006D0061006E0064002E0045007800650063007500740065004E006F006E0051007500650072007900280029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E005300630068006500640075006C00650072002E00530071006C004100670065006E007400480065006C007000650072002E004100640064004A006F006200280053007400720069006E00670020006A006F0062004E0061006D0065002C00200053007400720069006E00670020006A006F0062004F0077006E00650072002C00200053007400720069006E0067002000630061007400650067006F00720079004E0061006D00650029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E005300630068006500640075006C00650072002E00530071006C004100670065006E007400480065006C007000650072002E00520065006700690073007400650072005300630068006500640075006C00650028005300630068006500640075006C00650020007300630068006500640075006C00650029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E005300630068006500640075006C00650072002E00520065006700690073007400650072005300630068006500640075006C006500480065006C007000650072002E0050006500720066006F0072006D00440042004F007000650072006100740069006F006E00280029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E005300630068006500640075006C00650072002E00520065006700690073007400650072005300630068006500640075006C006500480065006C007000650072002E0045007800650063007500740065002800530071006C0043006F006E0074006500780074002000730071006C0043006F006E00740065007800740029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E005300630068006500640075006C00650072002E0043006F006D006D0061006E006400480065006C007000650072002E004500780065006300750074006500280029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E005300630068006500640075006C00650072002E005300630068006500640075006C006500720049006D0070006C002E00520065006700690073007400650072002800530071006C0043006F006E0074006500780074002000730071006C0043006F006E0074006500780074002C00200053007400720069006E00670020007300630068006500640075006C00650058006D006C0029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E004100670065006E0074004D0061006E0061006700650072002E0043006F006E006E00650063007400690076006900740079004A006F006200430072006500610074006F0072002E00520065006300720065006100740065004A006F006200280029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E004100670065006E0074004D0061006E0061006700650072002E0043006F006E006E00650063007400690076006900740079004A006F006200430072006500610074006F0072002E005200650063007200650061007400650043006F006E006E006500630074006900760069007400790052006500660072006500730068004A006F006200280029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E004100670065006E0074004D0061006E0061006700650072002E004100430055006E0069006E007300740061006C006C004D0061006300680069006E0065002E0043006C00650061006E005500700028004D0065007300730061006700650020006D007300670029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E005400610073006B004500780065006300750074006F0072002E00460073006D002E005400720061006E0073006900740069006F006E002E00450078006500630075007400650028004D0065007300730061006700650020006D007300670029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E005400610073006B004500780065006300750074006F0072002E00460073006D002E0045006E00670069006E0065002E004300680061006E00670065005300740061007400650028004D0065007300730061006700650020006D007300670029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E005400610073006B004500780065006300750074006F0072002E005400610073006B0049006E007300740061006E00630065002E00500072006F00630065007300730028004F0062006A006500630074002000640075006D006D00790029000D000A002000200020006100740020004D006900630072006F0073006F00660074002E0049006E007400650072006E0061006C002E0045006E0074006500720070007200690073006500530074006F0072006100670065002E0044006C0073002E005400610073006B004500780065006300750074006F0072002E00460073006D00540068007200650061006400460075006E006300740069006F006E002E00460075006E006300740069006F006E0028004F0062006A0065006300740020007400610073006B0054006800720065006100640043006F006E0074006500780074004F0062006A0029000D000A00200020002000610074002000530079007300740065006D002E0054006800720065006100640069006E0067002E0045007800650063007500740069006F006E0043006F006E0074006500780074002E00520075006E00280045007800650063007500740069006F006E0043006F006E007400650078007400200065007800650063007500740069006F006E0043006F006E0074006500780074002C00200043006F006E007400650078007400430061006C006C006200610063006B002000630061006C006C006200610063006B002C0020004F0062006A0065006300740020007300740061007400650029000D000A00200020002000610074002000530079007300740065006D002E0054006800720065006100640069006E0067002E005F0054006800720065006100640050006F006F006C005700610069007400430061006C006C006200610063006B002E0050006500720066006F0072006D005700610069007400430061006C006C006200610063006B0049006E007400650072006E0061006C0028005F0054006800720065006100640050006F006F006C005700610069007400430061006C006C006200610063006B002000740070005700610069007400430061006C006C004200610063006B0029000D000A00200020002000610074002000530079007300740065006D002E0054006800720065006100640069006E0067002E005F0054006800720065006100640050006F006F006C005700610069007400430061006C006C006200610063006B002E0050006500720066006F0072006D005700610069007400430061006C006C006200610063006B0028004F0062006A0065006300740020007300740061007400650029003C002F0045007800630065007000740069006F006E00440065007400610069006C0073003E003C002F0046006100740061006C0053006500720076006900630065004500720072006F0072003E00</Binary>
      </EventData>
    </Event>

    How I can debug this problem?


    Wojciech Sciesinski
    Monday, August 8, 2011 12:16 PM

All replies

  • Did you look at the status of your database?

    Open SQL Management Studio to take a look.

    Monday, August 8, 2011 1:10 PM
  • Hi,

    1) Check the registry on the DPM server and look under this path HKLM\software\microsoft\microsoft data protection manager\setup and look at the SchedulerJobOwnerName and SqlAgentAccountName entries. Check if they are set to accounts using UPN syntax - user@domain.com

    2) Change the values in the registry to be in the format of domain\user instead of user@domain.com

     


    Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, August 8, 2011 3:18 PM
    Moderator
  • Hi!

     

    I've changed values in the registry. DPM still crashes.


    Wojciech Sciesinski
    Monday, August 8, 2011 6:32 PM
  • Hi,

    By Default, the user in the registery entry is MachineName\MICROSOFT$DPM$Acct - make sure the user is also listed in SQL management studio under the LOGINS and that if you doubleclick the user, under Server Roles, both public and Sysadmin are checked, and under User Mappings, DPMDB, and the two ReportServer$... databses are selected.


    Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, August 8, 2011 6:59 PM
    Moderator
  • Hi,

     

    DPM was installed with domain user account.

    I've added the domain user in LOGINS and I've changed User Mapping but problem still exist


    Wojciech Sciesinski
    Monday, August 8, 2011 8:48 PM
  • Hi,

    We would probably need to dig in further and this cannot be done in a forum setting.  Something dealing with users on that SQL instance changed and so I would concentrate on what changed recently.   You can repair DPM installation using the following technet article, that has a good chance if fixing the issue:


    Regards, Mike J. [MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Monday, August 8, 2011 11:10 PM
    Moderator
  • Hi!

     

    I think that problem exist because MS SQL 2008 SP2 is used with MS DMP 2010.

     

    But I can't create backup DPM databases - solutions described in article submited by you doesn't work.

    c:\Program Files\Microsoft DPM\DPM\bin>DpmBackup.exe -db -instanceName MSSQLSERVER -certificates
    DpmBackup 1.0 - Data Protection Manager backup command-line tool
    Copyright (c) 2010 Microsoft Corporation. All rights reserved.
    
    Error: Failed to connect to server BRONZYT\mssqlserver.
    
    DpmBackup encountered an internal error. Check the Application Event Log for the
     cause of the failure. Fix the cause and retry the operation. For additional tro
    ubleshooting information, see the DPM Troubleshooting Guide.


    Can I do DPM database backup in another way e.g. SQL Management Console before reinstalling MS SQL 2008 and DPM 2010?

    I can't lose my DPM server data.


    Wojciech Sciesinski
    Monday, August 22, 2011 12:23 PM
  • DPM can't use SQL 2008 R2 so i doubt it can be combined with SP2 as it's quite new.

    http://technet.microsoft.com/en-us/library/ff399021.aspx

    Try using a SQL 2008 SP1 database.

     

    Try to backup using the SQL Management Console and restore it on a test server.

    Monday, August 22, 2011 2:10 PM
  • Hi

    I found this didn't get actually permanent fix, so below must be the solution.

    ERROR says : "Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails."

    The issue is SQL server collation, which is creating case sensitivity (It might be Collation is Latin1_General_BIN )

    Please refer : http://saurabhsinhainblogs.blogspot.in/2012/06/hi-all-today-we-faced-below-error-while.html


    Thanks Saurabh Sinha

    http://saurabhsinhainblogs.blogspot.in/

    Please click the Mark as answer button and vote as helpful if this reply solves your problem


    Thursday, January 30, 2014 9:44 AM