CHECK_MSSQL CRITICAL allways as output when use check_sql for MSSQL checking

[Arlen Drina]

Hi all,

I am using check_sql for checking MSSQL server ( or I would like to
check MSSQL servers ). I compiled
freetds with --with-tdsver=8.0 support on my debian system and all
went ok, in /etc/freetds.conf I have

[global]
        # TDS protocol version
#;	tds version = 4.2
        tds version = 8.0

# A typical Microsoft server
[MSSQL]
	host = sss.sss.sss.sss
	port = 1433
	tds version = 8.0

and when I run ./check_mssql -H sss.sss.sss.sss -p 1433 -U USER -P PASSWORD

I am constantly getting output

CHECK_MSSQL CRITICAL

Ok, I tried to solve this myself and I found at \

http://exchange.nagios.org/directory/Plugins/Databases/Others/check_sql/details
that is recommneded to change host-->server in line

my $cs = "DBI:$driver:" . ($database ? "database=$database;" : '') .
"server=$hostname" . ($port ? ";port=$port" : '');

so I changed that, but still I am getting same output for above command.

I am just trying to get minimal response from MSSQL server, connection
to port 1433 is open and I can connect via
telnet sss.sss.sss.sss 1433  and it works.

Any hint is welcome, I exhausted all my ideas, and thank you in advance

Nice regards,

Arlen

------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day 
trial. Simplify your report design, integration and deployment - and focus on 
what you do best, core application coding. Discover what's new with 
Crystal Reports now.  http://p.sf.net/sfu/bobj-july
_______________________________________________
Nagios-users mailing list
Nagios-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-users
::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. 
::: Messages without supporting info will risk being sent to /dev/null