Page 2 of 2
Re: MSSQL Query Issue
Posted: Tue Sep 29, 2020 4:19 pm
by ssax
Please try this 0.8.6 version out and see if it helps.
check_mssql_0.8.6.zip
Re: MSSQL Query Issue
Posted: Fri Oct 09, 2020 4:32 pm
by FrontlineIT
The plugin you provided did not work. Would it be ok for us to use an older version of a plugin? We have some older versions that are currently working with other instances
Re: MSSQL Query Issue
Posted: Mon Oct 12, 2020 3:12 pm
by ssax
Since you are seeing this error:
Please PM me what you are using for the -H option in the command so I can see if you've using IP or hostname. If you're using a hostname, does nslookup work against it? (to test DNS):
Technically, you can use any version of the plugin you want.
Do you have
php-odbc installed?
The latest MSSQL wizards should use php-odbc to connect but I'm pretty sure check_mssql uses
/etc/freetds.conf.
Please try editing your
/etc/freetds.conf and change this:
Code: Select all
[global]
# TDS protocol version
tds version = auto
To this:
Code: Select all
[global]
# TDS protocol version
tds version = 8.0
Then test again and let us know if that works.