I ma trying to monitor a SQL 2008 instance that is installed on a different drive letter than c:. I have tried modifying the install path to reflect the location in the type and host properties section, but have had no luck getting Hyperic to see the databases on the server. It does see the SQL agent and the Report server.
Any assistance is greatly appreciated.
As I understood, you CAN monitor SQL Agent and Report Server by hyperic agent, but hyperic agent didn't discover SQL DBs. Right ?
Please attach hyperic agent.log.
Does user which run hyperic agent has permission to connect to SQL Server Instance ?
Go to hyperic agent home and run:
java -jar bundles\agent-x86-64-win-5.8.0\pdk\lib\hq-pdk-5.8.0.jar -p mssql -Dplugins.include=mssql -Dlog=debug -m discover -a metric > debug.log
Attach created debug.log
As I see from your last debug log your SQL Server Instance installed on Drive C:
MsSQL 2008 MSSQLSERVER [C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL]
Let's check something . Go to perfmon (Start -> Run -> perfmon), press on "plus" to open "Add Counter" window look for "SQLServer:Databases" and press on it.
Attach your screenshot .