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.
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.