Mssql wizard configure nagiosxi

[mejokj]

Hi Team,

We are getting below error while adding mssql server using mssql wizard

Kindly suggest us on this issue?

root@NAGIOSXI ~]# /usr/local/nagios/libexec/check_mssql_server.php -H example.com --checktype 'database' -U 'nagios' -P 'Nagi0s123' --instancename 'Test' --perftype default -I 'test' -p 1433 --mode time2connect --warning 30 --critical 60

ERROR: [run_check] CRITICAL: Could not connect to odbc:Driver=FreeTDS;Server=example.com\Test as nagios (Exception: SQLSTATE[08S01] SQLDriverConnect: 20009 [FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist)

CRITICAL: Could not connect to odbc:Driver=FreeTDS;Server=example.com\test as nagios (Exception: SQLSTATE[08S01] SQLDriverConnect: 20009 [FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist

[cdienger]

Per https://support.nagios.com/kb/article/n ... d-735.html, edit /etc/freetds.conf and set this line:

Code: Select all

tds version = 7.2

and then test again and let us know your results. Please provide a copy of the freetds.conf file if you still have issues.