check_mssql_health unable to aquire counter data

This support forum board is for support questions relating to Nagios XI, our flagship commercial network monitoring solution.
Locked
zul.shariff
Posts: 8
Joined: Mon Jan 24, 2011 10:48 am

check_mssql_health unable to aquire counter data

Post by zul.shariff »

I installed the above plugin along with DBD::Sybase.
It works for --mode=connected-users but fails for modes such as total-server-memory.
The error I get is as follows:
UNKNOWN - unable to aquire counter data
Wed Feb 2 13:24:15 2011: disconnecting DBD with handle

the command I used is:
./check_mssql_health -v --hostname=<actual db server> --username=<db user> --password=<password> --mode=total-server-memory
rdedon
Posts: 578
Joined: Sat Nov 20, 2010 4:51 pm

Re: check_mssql_health unable to aquire counter data

Post by rdedon »

As this is being handled in email I am just making a note here.
Rene deDon
Technical Team
___
Nagios Enterprises, LLC
Web: http://www.nagios.com
sandyspatil
Posts: 15
Joined: Tue Dec 07, 2010 6:31 am

Re: check_mssql_health unable to aquire counter data

Post by sandyspatil »

Assign admin permission of mssql user which U R using while running the check_mssql_health plugin on MS Sql Server.
rdedon
Posts: 578
Joined: Sat Nov 20, 2010 4:51 pm

Re: check_mssql_health unable to aquire counter data

Post by rdedon »

Thank you for the suggestion :-)
Rene deDon
Technical Team
___
Nagios Enterprises, LLC
Web: http://www.nagios.com
Locked