Hyperic 5.8 with SQL 2008

[leeminwv]

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.

[admin]

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 ?

[leeminwv]

A copy of the log file is attached. The system databases are on a different drive letter than c:\

Thanks for your help.

[admin]

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

[leeminwv]

Please see attached.

Thanks

[admin]

Please stop an agent, run command again and attach updated debug.log

[leeminwv]

Sure. I have attached the file.

Thanks

[admin]

Hi,

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 .

Good Luck