MSSQL Configuration Issue

[aruln58]

Hello,

Could someone please assit on below.

When we try to test the configuration of SQL DB using AD account it is throwing below error. But the same is working fine when we using local account. Could you please check and assist on this.

[root@Host libexec]# ./check_mssql_server.php -H xx.xx.xx.xx--checktype 'database' -U 'domain\login' -P '**********--instancename 'master' --perftype default -p 1433 --mode time2connect --warning 1 --critical 5
ERROR: [run_check] CRITICAL: Could not connect to dblib:host=xx.xx.xx.xx:1433;dbname=master;charset=UTF8 as domain\login (Exception: SQLSTATE[01002] Adaptive Server connection failed (ipaddress:1433) (severity 9))
CRITICAL: Could not connect to dblib:host=xx.xx.xx.xx:1433;dbname=master;charset=UTF8 as domain\login (Exception: SQLSTATE[01002] Adaptive Server connection failed (xx.xx.xx.xx:1433) (severity 9)).

Note: We have already tried below steps
Nagios XI - MSSQL Wizards - Adaptive Server connection failed

[pbroste]

Hello @aruln58

Thanks for reaching out, appears that the issue is related to Adaptive Server connection failed. Even though the support kb is a bit outdated we see that the check_mssql_server.php is referencing '/etc/freetds.conf'.

Reference:

# A typical Microsoft server
[egServer73]
host = xxxxxxx.domain.com
port = 1433
tds version = 7.3

Here you can set host and set tds version.

Thanks,
Perry