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]

Did you ever solve this issue? I am getting the same error

[midjoule]

@blanm @Steven Watts2 ,

I've the same issue. Did you manage to resolve it ?

[m_srinivas_2011]

No, I've the same issue. Did you manage to resolve it ?

[midjoule]

No, still looking for a solution.

I just read this post which might help: https://www.servicenow.com/community/itom-forum/sql-db-discovery-issue/m-p/3122763/highlight/true#M1...

On the other hand, i read also that it might be a permission issue.