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

Ensure the file sits directly in /etc/zabbix/zabbix_agent2.d/ .

MSSQL: Failed to fetch info data (or no data for 30m) - Zabbix

It returns a massive JSON string packed with performance data. zabbix mssql failed to fetch info data -or no data for 30m-

This specific error in typically triggers when the monitoring system hasn't received any data from the MSSQL instance for a prolonged period (30 minutes), often due to ODBC configuration issues or insufficient permissions for the monitoring user . Alert Message Draft

-- Grant permissions in the msdb database USE msdb; CREATE USER zbx_monitor FOR LOGIN zbx_monitor; GRANT EXECUTE ON msdb.dbo.agent_datetime TO zbx_monitor; GRANT SELECT ON msdb.dbo.sysjobactivity TO zbx_monitor; GRANT SELECT ON msdb.dbo.sysjobservers TO zbx_monitor; GRANT SELECT ON msdb.dbo.sysjobs TO zbx_monitor; Ensure the file sits directly in /etc/zabbix/zabbix_agent2

Before we dive into the troubleshooting guide, let's explore some common causes of these errors:

user wants a long article about the Zabbix error "failed to fetch info data -or no data for 30m-" related to MSSQL monitoring. The plan outlines the steps. I'll follow the plan to search for relevant information. search results provide some relevant information. The first search result (0) is a Hungarian forum post that might contain useful details. The second result (1) is a Zabbix support page, and the fourth result (4) seems to be a general "no data for 30m" issue. I need to open these pages to gather more information. opened pages provide some information. The Hungarian forum post mentions ODBC drivers and permissions. The Zabbix support page (ZBX-24254) discusses timeout issues. The Leapswitch knowledgebase article provides general troubleshooting steps for MySQL, which might be adaptable. The ZBX-24106 page is about MySQL, not MSSQL. I need more specific information about the MSSQL template, ODBC driver installation, and troubleshooting steps. I'll search for more detailed resources. search results provide a good mix of official documentation, community discussions, and issue reports. The user's question has high authority requirements, I should prioritize using official Zabbix documentation and verified community reports. The error "MSSQL: Failed to fetch info data (or no data for 30m)" is likely due to ODBC connectivity issues, timeout misconfigurations, permission problems, or the Zabbix agent's inability to reach the MSSQL instance. The article should cover common causes: ODBC driver not installed, incorrect DSN configuration, missing or incorrect macros, Zabbix agent misconfiguration, connectivity issues (firewall, DNS, ports), missing permissions on the MSSQL user, query timeout limitations, and the need to increase timeouts in Zabbix configuration. The structure will include an introduction, a breakdown of root causes, a systematic troubleshooting guide, Zabbix configuration fixes, and a conclusion. I will cite relevant sources. search results provide enough information to write a comprehensive article. I will structure the article with an introduction, a breakdown of the root causes, a systematic step-by-step guide for troubleshooting, a dedicated section on Zabbix configuration adjustments (including the ODBC method and the Agent 2 plugin), a checklist, and a conclusion. error is one of the most common and frustrating problems when configuring Microsoft SQL Server monitoring in Zabbix. The alert triggers when Zabbix has not received new data from the target host for 30 minutes. For database monitoring, this typically means that Zabbix attempted to connect to the SQL Server but failed to retrieve data, resulting in a ZBX_NOTSUPPORTED status for the related items. Alert Message Draft -- Grant permissions in the

If you are using the with the native MSSQL plugin, the agent runs under a specific Windows user account. That account must have permissions to read SQL Server performance counters.