sql server - Data source name not found and no default driver specified - Zabbix

Question

I am trying to monitor an MSSQL database via ODBC with Zabbix, but I was getting an error that my DSN is invalid, even after performing several tests, does anyone have any idea what it could be?

/etc/freetds.conf

[MSSQL_SERVER]
    host = <ip>
    port = 1433
    tds version = 8.0

/etc/odbcinst.ini

[FreeTDS]
Description= FreeTDS Driver for Linux & MSSQL
Setup= /usr/lib64/libtdsodbc.so.0
Driver = /usr/lib64/libtdsodbc.so.0
UsageCount=1

/etc/odbc.ini

[MSSQL]
Driver = FreeTDS
Servername = MSSQL_SERVER

isql DSN

[root@zabbix]# isql MSSQL sa <password>
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> quit

tsql Servername

[root@zabbix]# tsql -S MSSQL_SERVER -U sa -P <password>
locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
1> quit

tsql conf

[root@zabbix]# tsql -C
Compile-time settings (established with the "configure" script)
                            Version: freetds v1.1.20
             freetds.conf directory: /etc
     MS db-lib source compatibility: yes
        Sybase binary compatibility: yes
                      Thread safety: yes
                      iconv library: yes
                        TDS version: auto
                              iODBC: no
                           unixodbc: yes
              SSPI "trusted" logins: no
                           Kerberos: yes
                            OpenSSL: no
                             GnuTLS: yes
                               MARS: yes

Error: Cannot connect to ODBC DSN: [SQL_ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found and no default driver specified]

Template:

question from:https://stackoverflow.com/questions/65922018/data-source-name-not-found-and-no-default-driver-specified-zabbix

Answer 1

Waitting for answers