DPM 2022: Error with Database Auto Protection after SQL upgrade

Sébastien Lagueux 31 Reputation points
2023-05-09T17:26:57.57+00:00

Hi

On a server I upgraded SQL 2019 to SQL 2022. Since that time, the DPM auto-protection failed for this server.

DPM could not enumerate SQL Server instances using Windows Management Instrumentation on the protected computer.

Start-AutoProtection : DPM could not enumerate SQL Server instances using Windows Management Instrumentation on the
protected computer XX. (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

I reinstalled the mof file:

PS C:\Program Files (x86)\Microsoft SQL Server\160\Shared> mofcomp .\sqlmgmprovider.mof
Microsoft (R) MOF Compiler Version 10.0.20348.1
Copyright (c) Microsoft Corp. 1997-2006. All rights reserved.
Parsing MOF file: .\sqlmgmprovider.mof
MOF file has been successfully parsed
Storing data in the repository...
Done!

Do you have an idea? Thanks!

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
894 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,210 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. LiHongMSFT-4306 25,326 Reputation points
    2023-05-10T03:04:53.1066667+00:00

    Hi @Sébastien Lagueux

    What is the build version for Data Protection Manager 2022? Please ensure running the correct DPM version.

    You can protect SQL Server 2022 with DPM 2022 UR1(10.22.148.0).

    See: SQL Server 2022 support.

    Best regards,

    Cosmog Hong

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.