zabbix proxy ODBC freetds MSSQLServer-Adaptive Server is unavailable or does not exis

[dde.silva]

I have a zabbix proxy dedicated to run queries on mssql server.

In the proxy (vm rocky linux) I installed unixODBC and freetds.

However, the item created on the same server of zabbix-proxy to execute the query is showing this error:
Cannot connect to ODBC DSN: [SQL_ERROR]:[08S01][20009][[unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist]|[08S01][20009][[unixODBC ][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist]|[08001][0][[unixODBC][FreeTDS][SQL Server]Unable to connect to data source]


When connecting to the database through the server using isql the connection is successful and its possible to run queries:
>>>
isql ABC user password
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+

When I run zabbix_get is showing this msg:
ZBX_NOTSUPPORTED: Unsupported item key.


>> /etc/odbcinst.ini
[FreeTDS]
Description = Free Sybase & MS SQL Driver
Driver = /usr/lib64/libtdsodbc.so.0
Trace = Yes
TraceFile = /tmp/freetds.log


>> /etc/odbc.ini
[ABC]
Driver = FreeTDS
Description = Database Monitor ABC
Server = 172.xx.xx.xx
Port = 1433
TDS_Version = 8.0
Database = ABC


>> Item zabbix




There is no error record in the server logs.

Zabbix Server: 6.0 on docker

Grateful if you can help me to solve the problem.

[danterpaniagua]

Hello, i have the same problem. You can solve it?