Greetings,
I feel like i'm stucked trying to deploy MSSQL by ODBC template in my Zabbix. I've been following different tutorials and even searched for help here in the forum but nothing seems to have fixed the problem.
So I have the following SO with Zabbix already working fine:
NAME="AlmaLinux"
VERSION="9.2 (Turquoise Kodkod)"
ID="almalinux"
ID_LIKE="rhel centos fedora"
VERSION_ID="9.2"
PLATFORM_ID="platform:el9"
I've followed the official documentation from Zabbix to deploy and configure MSSQL by ODBC: https://www.zabbix.com/integrations/mssql
However when I go to Zabbix to see if I'm monitoring the alerts I get the following error:
Cannot connect to ODBC DSN: [SQL_ERROR]:[HYT00][0][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired]|[08001][10013][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x271D]|[08001][10013][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishin]
The DSN, username and password is set in the macros. The SQL user logins correctly to MSSQL and I manage to connect from the zabbix server using isql -V
Telnet also works
I've tested windows odbc from a computer that is in the same network and it connects correctly (message is in spanish)
So at this point I dont understand where's the problem, looks like the connection is fine but Zabbix somehow cant connect.
Zabbix version is 6.4, I've tried also with odbc version 18, and also using the TDSFree driver or whatever is called but I have the same problem.
Any ideas?
Best regards
I feel like i'm stucked trying to deploy MSSQL by ODBC template in my Zabbix. I've been following different tutorials and even searched for help here in the forum but nothing seems to have fixed the problem.
So I have the following SO with Zabbix already working fine:
NAME="AlmaLinux"
VERSION="9.2 (Turquoise Kodkod)"
ID="almalinux"
ID_LIKE="rhel centos fedora"
VERSION_ID="9.2"
PLATFORM_ID="platform:el9"
I've followed the official documentation from Zabbix to deploy and configure MSSQL by ODBC: https://www.zabbix.com/integrations/mssql
However when I go to Zabbix to see if I'm monitoring the alerts I get the following error:
Cannot connect to ODBC DSN: [SQL_ERROR]:[HYT00][0][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired]|[08001][10013][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x271D]|[08001][10013][[unixODBC][Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishin]
The DSN, username and password is set in the macros. The SQL user logins correctly to MSSQL and I manage to connect from the zabbix server using isql -V
Telnet also works
I've tested windows odbc from a computer that is in the same network and it connects correctly (message is in spanish)
So at this point I dont understand where's the problem, looks like the connection is fine but Zabbix somehow cant connect.
Zabbix version is 6.4, I've tried also with odbc version 18, and also using the TDSFree driver or whatever is called but I have the same problem.
Any ideas?
Best regards
Comment