SQL DB discovery issue

sukran · ‎12-09-2024

While Discovering windows device we got error on SQL DB

Executing WMI query on host: ip address x.x.x.x with namespace: root/Microsoft/SqlServer and query: SELECT Name FROM __NAMESPACE

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 through the remote session. Original Exception: Invalid namespace "root/Microsoft/SqlServer" At line:1 char:5

sukran · ‎07-01-2025

Hello, You need to contact the Windows team to grant access to all communication paths or the highest path for discovering the SQL database, as indicated in the error message.

Example : The paths are as follows: (ComputerManagement 12, ComputerManagement 13, ComputerManagement 14, ComputerManagement 15, ComputerManagement 16).

The discovery process selects the most recent communication path, which in this case is ComputerManagement 16.

Please note: The pattern configuration is set to select the latest path available.

Additionally, for a permanent solution, ServiceNow has created a PRB record and plans to address this issue in the August patch. Issue: Instead of selecting the latest path, it should permit any of the available paths for discovering SQL.

View solution in original post

Sohail Khilji · ‎12-09-2024

Hi

try this :

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0816039

☑️ Please mark responses as HELPFUL or ACCEPT SOLUTION to assist future users in finding the right solution....

LinkedIn - Lets Connect

blanm · ‎04-02-2025

Were you able to find a solution for this? I am getting the same error

sukran · ‎04-05-2025

Yes we have fixed this issue . the SQL having multiple paths to access the database ( ex : ComputerManagement 12 , ComputerManagement 13 ,ComputerManagement 14 ,ComputerManagement 15 ,ComputerManagement 16) and depends on SQL version discovery automatically picks the path to access and the Issue is that read permission declined from SQL side

All you need to do is 1)provide SQL version on affected device and 2) In pattern logs which path its given error , these both information provide to relevant team( Windows / linux )team to provide access

MDAQUIBK · ‎06-27-2025

Hi @sukran

Could you Please help in this ? I am also facing the same issue.