February 27, 2024 at 4:30 am
Hi,
We are receiving alerts from SCOM regarding
WMI health has errors. MP has no access the following WMI name spaces and classes.
Message: SQL namespase is empty or version less than minimum version
Some links showing that providing access to the WMI name spaces will stop the alerts.
Is it better to provide the access to the run as account on WMI name spaces
Or
Recompile SQL WMI provider using mofcomp (Managed Object Format (MOF) compiler)
February 27, 2024 at 9:16 am
Get a copy of a WMI query, or get a WMI browser tool and try and run it as someone with admin rights, if the query fails because the namespace / class is invalid then you need to recompile the package, if it works, and all the namespaces and classes are as they should be then you need to look at permissions.
https://devblogs.microsoft.com/scripting/weekend-scripter-the-wmi-explorer-tool/
February 27, 2024 at 1:47 pm
It's probably permissions though. That's the most common issue here.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 29, 2024 at 11:41 am
Thanks,
We are not allowed to download. SCOM is not using run as account as the article mentioned. In that case we’re not sure what permission needs to check but we’re seeing this alert in one server but not on the other server which are same version.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply