zabbix agent : windows server.
zabbix proxy : linux server
zabbix server : linux server.
zabbix version:6.0
We have correctly configured ODBC on the Zabbix server. TSQL has been installed on the Zabbix proxy server, and the command "sudo -u zabbix tsql -S ip -U sa -P password " was executed successfully.
Therefore, the connection from Zabbix proxy to Zabbix agent is working.
However, when we try to retrieve data related to ODBC monitoring items from the Zabbix agent via the Zabbix proxy on the Zabbix server, an error occurs:
"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。".
odbc settings:
[test]
description = test
driver = FreeTDS
tds_version = 8.0
server = ip
port = 1433
How can we solve this problem?
Thank you for your answer!
zabbix proxy : linux server
zabbix server : linux server.
zabbix version:6.0
We have correctly configured ODBC on the Zabbix server. TSQL has been installed on the Zabbix proxy server, and the command "sudo -u zabbix tsql -S ip -U sa -P password " was executed successfully.
Therefore, the connection from Zabbix proxy to Zabbix agent is working.
However, when we try to retrieve data related to ODBC monitoring items from the Zabbix agent via the Zabbix proxy on the Zabbix server, an error occurs:
"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。".
odbc settings:
[test]
description = test
driver = FreeTDS
tds_version = 8.0
server = ip
port = 1433
How can we solve this problem?
Thank you for your answer!