MSSQL on Windows: WMI Health State Errors alerts receiving due to MP has no access to the following WMI namespaces and classes

shankar431 471 Reputation points
2021-07-05T16:21:24.54+00:00

Hi Team,

We are recieving MSSQL on Windows: WMI Health State Errors alerts due to Microsoft SQL Server on Windows (Monitoring) MP has no access to the following WMI namespaces and classes.

ALert description:
The WMI Health State on computer server.com reported an error. MP has no access to the following WMI namespaces and classes

The alert is generated by Monitor WMI Health State in the Microsoft SQL Server on Windows (Monitoring) MP.

Can you please help me on how to find out Which account/credentials needs access to these WMI namespaces.

Regards,
Ravi shankar

Operations Manager
Operations Manager
A family of System Center products that provide infrastructure monitoring, help ensure the predictable performance and availability of vital applications, and offer comprehensive monitoring for datacenters and cloud, both private and public.
1,417 questions
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. System Center guy 686 Reputation points
    2021-07-07T06:32:52.88+00:00

    Make sure that you grant “Execute Methods”, “Enable Account”, “Remote Enable”, “Read Security” permissions to SQL monitoring account for these WMI namespaces:
    root
    root\cimv2
    root\default
    root\Microsoft\SqlServer\ComputerManagement11 (if exists)
    root\Microsoft\SqlServer\ComputerManagement12 (if exists)
    root\Microsoft\SqlServer\ComputerManagement13 (if exists)
    root\Microsoft\SqlServer\ComputerManagement14 (if exists)
    root\Microsoft\SqlServer\ComputerManagement15 (if exists)

    Roger

  2. shankar431 471 Reputation points
    2021-07-07T06:55:44.087+00:00

    Hi All,

    Can any one help me with this alert.

    Regards,
    Ravi shankar

    0 comments