Nagios Support Forum

I am monitoring a few windows servers that have mount points attached. They are all MSSQL servers. Two are Windows Server 2003 R2 with MSSQL 2005 and default instances and two are Windows 2008 R2 with MSSQL2008 and named SQL instances. All return correct metrics except one. It is one of the 2008 servers. The errors I am getting are:

UNKNOWN - The WMI query had problems. The error text from wmic is: [wmi/wmic.c:196:main()] ERROR: Login to remote object.

I have verified that each server is configured to allow WMI exactly the same. They have the same user, same password, same permissions, same group membership. However, there is no luck. I have tried to run it with a domain admin account and still no luck. The account it uses is a local administrator with permissions to the Root of WMI, is part of the the DCOM group, Performance Log Users group, and Performance Monitoring Users group. When I run the wmi error code I receive the following response:

The operating system cannot run this application program.

Does anybody have any thoughts, on what is going on and how I might resolve it?

vhoover,

Can you test using WBEMtest and verify you can connect to the WMI provider remotely for a different Windows machine?

start > run > wbemtest

Thanks,

-Yancy

That server is accepting WMI queries, but the error still persists. I have tried from NagiosXI from two different accounts and still no luck. but if I try from SQL Server Mgmt Studio on my local box it works fine.

Can you post the example wmic query command you're using. Omit user credentials if needed.

Also, ensure that if you're using a domain name it's defined like this:
-Yancy

It ended up being a symptom of a bigger issue (an OS related issue), all other uses of the check_wmi_plus appear to work without issue.

did you manage to get it worked out then, or still having issues we can assist with?

I believe it has been worked out, thanks.

Excellent, we will close this thread for now.