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

If you can tell me the and if you are using ODBC or Agent 2 , I can provide more specific troubleshooting steps . Microsoft SQL monitoring and integration with Zabbix

Which and MSSQL template are you currently using? Is your Zabbix server running on Linux or Windows ?

: If using newer ODBC drivers (v18+), encryption is often forced. Try adding TrustServerCertificate=yes or Encrypt=yes to your connection string or odbc.ini file.

Before assuming it works, test the ODBC configuration directly from the Zabbix server's shell. Use the isql command, which is part of the unixODBC package: zabbix mssql failed to fetch info data -or no data for 30m-

ybcnyc. Junior Member. Joined: Jun 2022. Posts: 1. MSSQL monitoring - MSSQL: Failed to fetch info data (or no data for 30m) 16-06-

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

Use the command line to test connectivity directly: isql -v Use code with caution. If you can tell me the and if

If the data flow has stopped, any number of things could have gone wrong. The table below outlines the most common root causes, categorizing them by the layer at which the failure occurs.

This article will guide you through the root causes and provide actionable steps to resolve this issue in modern Zabbix versions (6.0+). Understanding the Error

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. : If using newer ODBC drivers (v18+), encryption

Zabbix requires specific permissions to query SQL Server performance data. If the user defined in $MSSQL.USER and $MSSQL.PASSWORD lacks these, data collection fails.

The monitoring database user requires specific privileges. Without VIEW SERVER STATE permission, the user cannot access the dynamic management views (DMVs) that provide performance counters and instance information.

She clicked on the item: MSSQL: User activity per minute .

She wrote in her post-mortem: "Zabbix did not lose the data. We lost the ability to fetch it. The silence was the alarm."