MSSQL databases not getting discovered

[Karthik37]

Hi Folks,

We are trying to discover our MSSQL databases and while doing the discovery we are able to discover the instances, DBs for few servers and for few servers we are able to discover only the instances and not DBs. While checking the pattern we get the below error. Any suggestions on this error?

WMI query on host xx.xx.xx.xx failed. query: SELECT Name FROM Win32_PerfFormattedData_MSSQLSERVER_SQLServerDatabases error: Invalid class

WMI query on host xx.xx.xx.xx failed. query: SELECT Name FROM Win32_PerfFormattedData_MSSQLMSSQLSERVER_MSSQLMSSQLSERVERDatabases error: Invalid class

Little more detail:

This is getting executed in pattern "MSSql DB On Windows" and step "Get list of db from wmi" under identification for MS SQL server.

[Ashutosh Munot1]

HI,

This is it:

https://hi.service-now.com/kb_view.do?sysparm_article=KB0716415

Thanks,

Ashutosh

[Karthik37]

Hi Ashutosh,

This article is for older versions and we are currently on New York.

[Ashutosh Munot1]

HI,

Can you check your database instance name? 

THanks

Ashutosh

[Ashutosh Munot1]

HI,

Also check by adding Applicative credentials there.

Thanks,
Ashutosh