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@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