MSSQL Query Issue

[ssax]

Please try this 0.8.6 version out and see if it helps.

check_mssql_0.8.6.zip

[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

[ssax]

Since you are seeing this error:

Code: Select all

Unknown host machine name

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):

Code: Select all

nslookup YOURHOSTNAME

Technically, you can use any version of the plugin you want.

Do you have php-odbc installed?

Code: Select all

rpm -qa | grep php-odbc

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.