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

Question

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

Answer 1

Hi All,

Below link helped us to solve our issue.

https://learn.microsoft.com/en-us/troubleshoot/sql/tools/error-message-when-you-open-configuration-manager

Regards,
Ravi shankar

Answer 2

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

Answer 3

Hi All,

Can any one help me with this alert.

Regards,
Ravi shankar