This 3,000+ word guide will leave no stone unturned. We’ll cover the root causes, the debugging workflow, and the permanent fixes for the Zabbix-MSSQL integration breakdown.
Remember: Use the diagnostics in this guide to enforce a 15-minute maximum data outage, and set up proactive alerts for the monitoring system itself.
tail -f /var/log/zabbix/zabbix_server.log | grep -i "mssql\|odbc\|failed\|no data"
For a database administrator or a monitoring engineer, this is a high-priority alert. It implies that Zabbix has lost visibility into your SQL Server instance. Is the database down? Is the network blocked? Or is it just a permissions hiccup?
timeout 10 $MSSQL_CMD -S $SERVER -d $DB -Q "$QUERY" -W -h -1 > /dev/null 2>&1
MSSQL: Failed to fetch info data (or no data for 30m) - ZABBIX Forums