Messages similar to the following appear in the SQL Server (DBSS) Agent logs:
2012-02-21 11:49:49.593 ECHO <DB_SQL_Server/5.5.8.568/DB_SQL_Server/DBSS-alpha.test.com-MYSERVER-agent> ERROR [DBSS-alpha.test.com-MYSERVER-wmiThreadPool-1-[DBSS_Usability][2012/02/21 11:49:49]] com.quest.qsi.fason.sqlserver.collection.processor.DBSSUsabilityOSProcessor - no data was returned from WMI query os_is_service_up.
The SQL Server Services query cannot be retrieved through WMI from the monitored host.
In order to correctly monitor the SQL Server Services, the successful result should be retrieved from the WMI query "select * from Win32_Service" (see attachment)
This can be tested by using Microsoft's WBEMTEST application.
1). Run the program WBEMTEST from the Windows Run field.
2). Click the connect button
3). Enter the server name in the namespace followed by root\cimv2, in this example it might be \\alpha.test.com\root\cimv2
4). Enter the username and password.
5). Click the connect button again.
6). Click the query button
7). Enter the query "select * from Win32_Service" (without quotes)
8). Click the Apply button
If this query cannot be retrieved, we recommend engaging Microsoft Support to assist with this issue.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center