question

shankar431-9012 avatar image
0 Votes"
shankar431-9012 asked shankar431-9012 answered

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

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

msc-operations-manager-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

shankar431-9012 avatar image
0 Votes"
shankar431-9012 answered

Hi All,

Below link helped us to solve our issue.

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

Regards,
Ravi shankar

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RogerXue-3369 avatar image
0 Votes"
RogerXue-3369 answered shankar431-9012 commented

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

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Roger,

*SQL monitoring account means are you talking about Database reader/writer service accounts (svcscom-dbr or svcscom-dbw).
Can you please confirm for which account we need to grant the above permissions .

Regards,
Ravi shankar



0 Votes 0 ·

Hi Roger,

We are using SQL run as addendum management pack.This MP dont use any run as account.

0 Votes 0 ·

Hi Roger,

Can you please provide update on my doubt.

regards,
Ravi shankar

0 Votes 0 ·
shankar431-9012 avatar image
0 Votes"
shankar431-9012 answered

Hi All,

Can any one help me with this alert.

Regards,
Ravi shankar

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.