Database Auto-Protection Failed DPM

This error occurs when WMI is not properly working on Protected SQL servers. You can check on which server this occurs by running the AutoProtectInstances.ps1 Powershell script in the DPM Management Shell. What this script does is checking for new SQL instances that are added to your protected SQL Servers.

Error Database Auto-Protection Failed

 

The Powershell script will try to connect to the SQL server which protected by a Protection Group.
In the screenshot you see the servername. Error AutoProtectInstances

You can check if WMI is properly working by following the steps below:

  • Run WBEMTEST.exe
  • Click Connect and  connect to: \\<SQL SERVER>\root\Microsoft\sqlserver\computermanagement10
  • Query using the following WQL query: SELECT * From ServerSettings
    If that class is missing, this query will fail with the error number: 0x80041010 and Description: Invalid Class.

If you get the error above you can resolve it by logging in to the SQL Server and running the following command:

  • mofcomp “C:\Program Files (x86)\Microsoft SQL Server\100\Shared\sqlmgmproviderxpsp2up.mof”

This will register the right WMI classes.

When you go back to your DPM Management Console the error will be gone automatically.

leave your comment