2012 R2 DPM - Database Auto Protection Failed - Mofcomp succeeds - autoprotectinstances.ps1 fails with WMI error RRS feed

  • Question

  • I've been chasing this around for a while now. I am running 2012 DPM update 6 with 2012 SQL. The database auto protection fails, I then run mofocomp "C:\Program Files (x86)\Microsoft SQL Server\110\Shared\sqlmgmprovderxpsp2up.mof" and it succeeds. Finally, I run AutoProtectInstances.ps1 and it fails with the error below:

    Any help is appreciated.

    Start-AutoProtection : DPM could not enumerate SQL Server instances using
    Windows Management Instrumentation on the protected computer
    DPMComputer.WSDOT.LOC. (ID: 965)
    Please make sure that Windows Management Instrumentation for SQL server is in
    good state.
    At C:\Program Files\Microsoft System Center 2012
    R2\DPM\DPM\bin\AutoProtectInstances.ps1:10 char:1
    + Start-AutoProtection -DPMServerName $DPMServerName -confirm:$false
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        + CategoryInfo          : NotSpecified: (:) [Start-DPMAutoProtection], Dls
        + FullyQualifiedErrorId : UnableToEnumerateSQLInstances,Microsoft.Internal

    Tuesday, June 16, 2015 2:27 PM

All replies

  • I had 2014 SQL on this server. I uninstalled it and installed 2012 due to 2014 not being supported, only as an upgrade and after RU 6.

    I think there was a registry key or setting that persisted and was affecting DPM. Wiped it and everything is working.

    Thursday, June 18, 2015 4:30 PM