DPM 2019 does not recognize protcted SQL Server version after upgrade

Tibor Marchyn 21 Reputation points
2021-12-06T12:40:47.203+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,152 questions
{count} votes

Accepted answer
  1. Tom Phillips 17,741 Reputation points
    2021-12-06T15:17:19.727+00:00

    Your question is about System Center. I suggest you post your question here:
    https://techcommunity.microsoft.com/t5/system-center/ct-p/SystemCenter


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.