Zabbix Mssql Failed To Fetch Info Data -or No Data For 30m- (2025-2026)

The Zabbix Agent service runs as a local Windows user (typically SYSTEM). This account often does not have permissions to read SQL performance counters or query the SQL instance.

Diagnosis: If the error logs suggest "Access Denied" or return null values for metrics.

Solution: Grant the necessary permissions to the Zabbix Agent service account. zabbix mssql failed to fetch info data -or no data for 30m-

If the SQL service is running, the issue might be between the Zabbix Server and the Agent on the SQL host.

On the Zabbix Server, run:

zabbix_get -s <TARGET_IP> -k agent.ping

tail -f /var/log/zabbix/zabbix_server.log | grep -i "mssql\|odbc\|failed\|no data"

Look for specific SQL error codes (e.g., SQL_ERROR or HYT00 = timeout).

CREATE LOGIN zabbix_svc WITH PASSWORD = 'StrongPwd!';
CREATE USER zabbix_svc FOR LOGIN zabbix_svc;
GRANT VIEW SERVER STATE TO zabbix_svc;
GRANT VIEW ANY DATABASE TO zabbix_svc;
GRANT CONNECT SQL TO zabbix_svc;

Do not use sa or sysadmin – it’s a security risk and often blocked by compliance. The Zabbix Agent service runs as a local

Example:

telnet <MSSQL_server_IP> 1433

If the connection is successful, you should see a blank screen. If the SQL service is running, the issue