IPU was done on SCCM Server
OS 2016->2022
SQL 2016->2022
WMI has 2 paths:
\\SCCMServer\ROOT\Microsoft\SqlServer\ComputerManagement13
SELECT * FROM ServerSettings
returns nothing
\\SCCMServer\ROOT\Microsoft\SqlServer\ComputerManagement16
SELECT * FROM ServerSettings
InstanceName
MSSQLSERVER
DPMRACurr.errlog
05/22 05:01:17.516 03 WMIQueryHelper.cpp(145) [000000F51D7FE500] 3231411E-317A-40C2-8A87-BF4F8FA4C25D WARNING Failed: Hr: = [0x80041013] : unable to execute the WQL query: SELECT * FROM ServerSettings
396C 3AA8 05/22 05:01:17.516 61 SqlMirroringHelper.cpp(175) [000000F51D7FEB10] 3231411E-317A-40C2-8A87-BF4F8FA4C25D WARNING Failed: Hr: = [0x80041013] : Encountered Failure: : lVal : wmiQueryHelper.ExecuteWQLQuery(ssWMIQuery)
396C 3AA8 05/22 05:01:17.516 61 SqlMirroringHelper.cpp(81) [000000F51D7FEB10] 3231411E-317A-40C2-8A87-BF4F8FA4C25D WARNING Failed: Hr: = [0x80041013] : unable to get instance names from sql 2016 wmi: lVal : GetInstanceNamesFromWMI(ssWMINamespace, arrLocalInstanceNames)
396C 3AA8
Issue: DPM 2022 throws Error when trying to autoprotect instances:
PS C:\Program Files\Microsoft System Center 2022\DPM\DPM\bin> .\AutoProtectInstances.ps1 -DPMServerName DPMServername
WARNING: This can take several minutes to few hours depending on the number of datasources protected.
Start-AutoProtection : DPM could not enumerate SQL Server instances using Windows Management Instrumentation on the
protected computer SCCMServer.some.domain. (ID: 965)
Please make sure that Windows Management Instrumentation for SQL server is in good state.
At C:\Program Files\Microsoft System Center 2022\DPM\DPM\bin\AutoProtectInstances.ps1:10 char:1
+ Start-AutoProtection -DPMServerName $DPMServerName -confirm:$false
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Start-DPMAutoProtection], DlsException
+ FullyQualifiedErrorId : UnableToEnumerateSQLInstances,Microsoft.Internal.EnterpriseStorage.Dls.UI.Cmdlet.StartAu
toProtection
