The Zabbix monitoring user requires specific permissions to pull performance data. If these are missing, the "fetch info data" item will fail. :
Problem: MSSQL: Failed to fetch info data (or no data for 30m) zabbix mssql failed to fetch info data -or no data for 30m-
The Zabbix monitoring user requires specific permissions to access system views and performance counters. If these are missing, the query that fetches "info data" will fail. Ensure the monitoring user has these permissions: SERVER STATE [zabbix_user]; DEFINITION [zabbix_user]; -- For SQL Agent jobs monitoring: dbo.sysjobs [zabbix_user]; dbo.sysjobactivity [zabbix_user]; dbo.agent_datetime [zabbix_user]; Use code with caution. Copied to clipboard 2. ODBC Driver Configuration (Zabbix Server/Proxy) The Zabbix monitoring user requires specific permissions to
recovery_expression: | last(/MSSQL_Template/ms.sql.fetch_success)=1 and min(/MSSQL_Template/ms.sql.fetch_success, 5m)=1 If these are missing, the query that fetches
logrt["/var/log/zabbix/zabbix_server.log","failed to fetch info data",,,skip]
On your MSSQL Host in the Zabbix UI, update the following Macros : $MSSQL.USER : zbx_monitor $MSSQL.PASSWORD :