After IPU of SCCM Server with SQL 2016->2022 DPM Fails to enumerate SQL Instances
IPU was done on SCCM Server
OS 2016->2022
SQL 2016->2022
WMI has 2 paths:
\SCCMServerROOTMicrosoftSqlServerComputerManagement13
SELECT * FROM ServerSettings
returns nothing
\SCCMServerROOTMicrosoftSqlServerComputerManagement16
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 FilesMicrosoft System Center 2022DPMDPMbin> .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 FilesMicrosoft System Center 2022DPMDPMbinAutoProtectInstances.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
IPU was done on SCCM Server OS 2016->2022SQL 2016->2022WMI has 2 paths:\SCCMServerROOTMicrosoftSqlServerComputerManagement13SELECT * FROM ServerSettingsreturns nothing\SCCMServerROOTMicrosoftSqlServerComputerManagement16SELECT * FROM ServerSettingsInstanceNameMSSQLSERVERDPMRACurr.errlog05/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 ServerSettings396C 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 3AA8Issue: DPM 2022 throws Error when trying to autoprotect instances:PS C:Program FilesMicrosoft System Center 2022DPMDPMbin> .AutoProtectInstances.ps1 -DPMServerName DPMServernameWARNING: 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 theprotected computer SCCMServer.some.domain. (ID: 965)Please make sure that Windows Management Instrumentation for SQL server is in good state.At C:Program FilesMicrosoft System Center 2022DPMDPMbinAutoProtectInstances.ps1:10 char:1+ Start-AutoProtection -DPMServerName $DPMServerName -confirm:$false+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ CategoryInfo : NotSpecified: (:) [Start-DPMAutoProtection], DlsException+ FullyQualifiedErrorId : UnableToEnumerateSQLInstances,Microsoft.Internal.EnterpriseStorage.Dls.UI.Cmdlet.StartAutoProtection Read More