Summary

If the SQL Server WMI provider cannot be accessed when the FlexNet inventory agent gathers inventory from a computer then a "SQL Server (Unknown component)" application may be the only SQL Server-related application that gets recognized as installed, and no application that identifies the installed SQL Server edition is recognized.

Troubleshooting

There can be a range of causes why the SQL Server WMI provider cannot be accessed, including the provider not being installed, or some problem in the WMI subsystem.

A Windows PowerShell command like the following can be executed (with local administrator rights) to attempt to perform similar WMI queries to those used by the FlexNet inventory agent during inventory gathering to identify the SQL Server edition. A sample script is attached to this article.

Get-WmiObject -Namespace 'root\Microsoft\SqlServer' __NAMESPACE |
? { $_.Name -match 'ComputerManagement' } |
%{
	$ns = "$($_.__NAMESPACE)\$($_.Name)"

	Write-Host "Querying namespace $ns"

	Get-WmiObject -Namespace $ns -Class SqlServiceAdvancedProperty -Filter "SqlServiceType = 1 AND PropertyName = 'SKUNAME'" |
	Select PSComputerName, ServiceName, PropertyName, PropertyStrValue
	
	Write-Host ""
}

Successful output from this script looks like the following:

The attached script can also be used to troubleshoot this SQL edition recognition. This script includes the Powershell script listed above and is more comprehensive as it will also gather SQL related information from the registry. This can potentially be used to evaluate the present of various SQL components and their editions. 

Alternatively, the wbemtest tool can also be used to test the ability to query information from the SQL Server WMI provider:

1. On the computer where SQL Server is running, launch 'wbemtest' from the run menu.
   
   
2. Click Connect... and connect to the appropriate WMI namespace according to the version of SQL Server that is installed, as per the following table:

   SQL Server version	$namespace
   2005 & earlier	root\Microsoft\SqlServer\ComputerManagement
   2008	root\Microsoft\SqlServer\ComputerManagement10
   2012	root\Microsoft\SqlServer\ComputerManagement11
   2014	root\Microsoft\SqlServer\ComputerManagement12
   2016	root\Microsoft\SqlServer\ComputerManagement13
   2017	root\Microsoft\SqlServer\ComputerManagement14
   2019	root\Microsoft\SqlServer\ComputerManagement15

   
   
3. After connecting to the namespace, click Enum Instances... and do a search for "SqlServiceAdvancedProperty" in the superclass name field.
   
   Look for any objects named "MSSQL$<instance name>" with a ServiceType of 1 in the query  results:
   

If any of the above steps fail, the FlexNet inventory agent is unlikely to be able to gather sufficient details to be able to recognize the installed edition of SQL Server.

Remediation

The following page provides helpful guidance for remediating problems with the SQL Server WMI provider: Error message when you open SQL Server Configuration Manager in SQL Server: Cannot connect to WMI provider. You do not have permission or the server is unreachable

As described on that page, executing a "mofcomp" command similar to the following may be able to be used to configure the WMI provider:

For example:

Additional Information

It's possible to verify the Edition value stored in the SKUNAME property in WMI as well by running the following query after connecting to the namespace in wbemtest:

select * from SqlServiceAdvancedProperty where SQLServiceType = 1 AND PropertyName = 'SKUNAME'

If there are no problems accessing the SQL Server WMI provider, another possible reason why a SQL Server (Unknown component) application is recognized is that the ARL does not contain a rule to recognize your specific SQL Server details. Flexera Support will be able to help identify this situation if you share an inventory NDI file from an affected computer.