Discovery - quick disovery failing to create CI for the MID server host

[Steven Watts2]

Hi,

I'm running a quick discovery on the host where we have installed a MID Server but i'm getting the following error:

2024-10-24 09:04:46: Executing WMI query on host: [IP ADDRESS REMOVED] with namespace: root/Microsoft/SqlServer and query: SELECT Name FROM __NAMESPACE

2024-10-24 09:04:46: Error during execution of Windows command: executeQuery -Namespace root/Microsoft/SqlServer -Query "SELECT Name FROM __NAMESPACE" due to com.snc.automation_common.integration.exceptions.InvalidCommandException: executeQuery : Could not get query SELECT Name FROM __NAMESPACE on namespace=root/Microsoft/SqlServer. Original Exception: Invalid namespace
At line:1 char:5
+ & { executeQuery -Namespace root/Microsoft/SqlServer -Query "SELECT N ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,executeQuery

Can anyone explain to what this error actually means?

[blanm]

We believe it has to do with our server team hardening permissions around our midserver's ability to run WMI queries against the server (for us, we suddenly stopped discovering MSSQL instances, which were showing this same error in the MSSQL DB on Windows pattern). We did reach out to them and they said they would take a look, and suddenly some of them started showing up as discovered successfully again. They didnt tell us what they did though, still waiting to hear back.