Zabbix Mssql Failed To Fetch Info Data -or No Data For 30m- -

Use this checklist to systematically eliminate the error:

-- Grant server-level permissions GRANT VIEW SERVER STATE TO zbx_monitor; GRANT VIEW ANY DEFINITION TO zbx_monitor; -- Grant both for comprehensive monitoring

If the script takes 15 seconds to run, but the Zabbix timeout is set to 3 seconds (default), the connection is cut. Zabbix registers this as a failed fetch. If this happens repeatedly, the item goes into a "Not Supported" state for a period (often 10-30 minutes) before retrying, causing the "No data for 30m" gap.

Zabbix templates scan SQL Server Agent jobs to monitor backup and automation tasks. Grant explicit read permissions inside the msdb database: zabbix mssql failed to fetch info data -or no data for 30m-

The error in Zabbix typically indicates a breakdown in communication between the Zabbix monitoring component (Server, Proxy, or Agent 2) and the Microsoft SQL Server instance. This alert triggers when the primary "Get status" item, which populates dependent items with JSON data, returns an empty value or fails to execute. 1. Resolve Authentication and Permissions

Fetching MSSQL metrics (especially database sizes or heavy performance counters) can take longer than the default Zabbix timeout.

: Ensure that ODBC pollers are active by setting StartODBCPollers to at least 1 in your zabbix_server.conf or zabbix_proxy.conf file. Use this checklist to systematically eliminate the error:

Crucially, put credentials in the odbc.ini file. Zabbix requires them in these macros, as clearly stated in the official documentation.

: Double-check credentials and ensure the SQL Server allows "SQL Server and Windows Authentication mode." 4. Agent 2 Specific Fixes If you are using Zabbix Agent 2 with the MSSQL plugin:

USE msdb; CREATE USER zbx_monitor FOR LOGIN zbx_monitor; GRANT SELECT ON msdb.dbo.sysjobs TO zbx_monitor; GRANT SELECT ON msdb.dbo.sysjobservers TO zbx_monitor; GRANT SELECT ON msdb.dbo.sysjobactivity TO zbx_monitor; GRANT EXECUTE ON msdb.dbo.agent_datetime TO zbx_monitor; Zabbix templates scan SQL Server Agent jobs to

PiotrJ. Junior Member. Joined: May 2023. Posts: 26. Problem: MSSQL: Failed to fetch info data (or no data for 30m) 21-09-2023, 19:

: If you can connect via sqlcmd but not Zabbix, you may need to specify TrustServerCertificate=Yes in your odbc.ini file or ensure the Microsoft ODBC Driver 18 is properly handling encryption. Database Permissions