Your question is about System Center. I suggest you post your question here:
https://techcommunity.microsoft.com/t5/system-center/ct-p/SystemCenter
DPM 2019 does not recognize protcted SQL Server version after upgrade
Hi,
we have upgraded DPM 2019 protected SQL Server from 2016 to 2017 in-place. Protection works but DPM still saying that auto-protection failed.
I have looking into logs and see that DPM is still querying SQL version 2016 instead of 2017 over WMI. It didn't recognized that SQL was upgraded and Refresh in protection group showing same error regarding WMI.
I have figured it through Process Monitor and saw wmiprvse.exe asking for following path
HKLM\SOFTWARE\Microsoft\Wbem\CIMOM\SecuredHostProviders\ROOT\Microsoft\SqlServer\ComputerManagement13:__Win32Provider.Name="MSSQL_ManagementProvider"
but it should be
HKLM\SOFTWARE\Microsoft\Wbem\CIMOM\SecuredHostProviders\ROOT\Microsoft\SqlServer\ComputerManagement14:__Win32Provider.Name="MSSQL_ManagementProvider"
I have tried to remove all backups, uninstall agent, install again and add targets, but wmi error keeps showing.
In DPM agent logs is
0778 2734 12/06 12:10:43.764 03 wmiqueryhelper.cpp(145) [00000069D6E7EC60] FA6F4362-B271-46FC-9120-54A46E9F8755 WARNING Failed: Hr: = [0x80041013] : unable to execute the WQL query: SELECT * FROM ServerSettings
0778 2734 12/06 12:10:43.764 61 sqlmirroringhelper.cpp(175) [00000069D6E7F260] FA6F4362-B271-46FC-9120-54A46E9F8755 WARNING Failed: Hr: = [0x80041013] : Encountered Failure: : lVal : wmiQueryHelper.ExecuteWQLQuery(ssWMIQuery)
0778 2734 12/06 12:10:43.764 61 sqlmirroringhelper.cpp(81) [00000069D6E7F260] FA6F4362-B271-46FC-9120-54A46E9F8755 WARNING Failed: Hr: = [0x80041013] : unable to get instance names from sql 2016 wmi: lVal : GetInstanceNamesFromWMI(ssWMINamespace, arrLocalInstanceNames)
Is it possible somehow manually update protected SQL Server version from 2016 to 2017 in DPM 2019? In database or any file or registry?
Thanks
-
Tom Phillips 17,741 Reputation points
2021-12-06T15:17:19.727+00:00