Is it possible to use this sensor on an SQL server that is not in the same domain as the probe? Please note that I have many other WMI sensors that connect to this DMZ server just fine, so firewall and other authentication issues are unlikely.
I am also having trouble with the Microsoft SQL sensor on the same DMZ server. It does not work with Windows Authentication. It works fine with SQL Server authentication.
I suspect these two problems are related.