Alert from sql managementpack

Dashboard Server
,
1

Hi, we have this alert on just one sql server in our environment and doesn’t find the solution. Any idea?

The WMI Health State on computer 'servername' reported an error. WMI has no access:
Path: '\\'servername'\root\Microsoft\SqlServer\ComputerManagement11' and class: 'ServerNetworkProtocol'
Path: '\\'servername'\root\Microsoft\SqlServer\ComputerManagement11' and class: 'ServerNetworkProtocolProperty'
2

Hi

Have you tried this?

https://support.microsoft.com/en-in/help/956013/error-message-when-you-open-sql-server-configuration-manager-in-sql-se

I had that error on a couple of SQL servers when setting up monitoring.

1 Like
3

I had the same issue after several of our vmware hosts crashed yesterday. Using “WMI Explorer” I could confirm that most sqlserver classes were missing from WMI. Fixed it by following this blog post:

https://claudioessilva.eu/2017/09/07/invalid-class-0x80041010-while-trying-to-access-sqlserver-wmi-classes/

(looks like it’s the same instructions as the MS support article.

4

Thanks, these 2 commands solved the problem