zabbix_get -s <TARGET_IP> -k agent.ping
Create the zabbix_svc login on all nodes of the cluster and grant permissions via a server-level trigger that executes on failover.
To troubleshoot the "Failed to fetch info data" or "No data for 30m" errors, follow these steps:
Your_Template:mssql.info.fetch.fail.min(30m)=1 or Your_Template:mssql.info.fetch.data.nodata(30m)=1
If you monitor dozens of SQL Server instances per agent, the default polling may collapse. zabbix mssql failed to fetch info data -or no data for 30m-
Performance counters are fragile (localization, missing objects). For critical metrics, use db.odbc.select with custom T-SQL.
Driver-plugin version mismatch or missing VIEW SERVER STATE permissions
This is a generic trigger often seen when using the "MSSQL by ODBC" or "MSSQL by Zabbix agent 2" templates. It indicates that the master "Info" item—which discovery and other dependent items rely on—is not receiving data. Core Causes & Fixes 1. Database Permissions (Most Common)
On the SQL Server, open → System DSN → Create a test DSN pointing to your instance. zabbix_get -s <TARGET_IP> -k agent
This file defines your actual connection to the SQL Server instance. Edit /etc/odbc.ini and add an entry. The section name you choose here (e.g., [MSSQL_PROD] ) will be used in your Zabbix macros.
Restart the Zabbix Agent 2 service to apply these changes. Common Troubleshooting Steps
ybcnyc. Junior Member. Joined: Jun 2022. Posts: 1. MSSQL monitoring - MSSQL: Failed to fetch info data (or no data for 30m) 16-06-
: If using the Zabbix Agent 2 plugin, ensure you have configured the mssql.conf file (located in zabbix_agent2.d/plugins.d/ ) with the correct URI, username, and password. Diagnostic Steps For critical metrics, use db
The monitoring user needs very specific permissions to query the correct performance data. Using the "sa" account is not recommended. Follow the official guidance and grant the following permissions on your SQL Server:
This problem generally stems from configuration conflicts in one of two monitoring methods: the traditional or the newer native Zabbix Agent 2 Plugin method . Root Causes Overview
If SQL Server is using a dynamic port or if a firewall is blocking the connection, the master item will fail.