Hi,
I'm trying to configure a database monitor for a MSSQL database using 'Database monitor' as type with db.odbc.select[] as key.
I thing i have well configured odbc.ini & odbcinst.ini file but I still have an error on zabbix :
Cannot connect to ODBC DSN: [SQL_ERROR]:[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]
I'm using a zabbix proxy (v4.0) with a specific SourceIP on zabbix_proxy.conf and firewall only allow traffic from this SourceIP to my mssql server on port 1433/tcp (mssql port).
When I launch a tcpdump (tcpdump dst <my mssql server> and port 1433) I only see traffic with zabbix proxy as source and nothing with SourceIP as source.
I have miss something or does database monitor use SourceIP or ServerIP ?
Regards
I'm trying to configure a database monitor for a MSSQL database using 'Database monitor' as type with db.odbc.select[] as key.
I thing i have well configured odbc.ini & odbcinst.ini file but I still have an error on zabbix :
Cannot connect to ODBC DSN: [SQL_ERROR]:[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]
I'm using a zabbix proxy (v4.0) with a specific SourceIP on zabbix_proxy.conf and firewall only allow traffic from this SourceIP to my mssql server on port 1433/tcp (mssql port).
When I launch a tcpdump (tcpdump dst <my mssql server> and port 1433) I only see traffic with zabbix proxy as source and nothing with SourceIP as source.
I have miss something or does database monitor use SourceIP or ServerIP ?
Regards
Comment