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

Driver=ODBC Driver 17 for SQL Server;Server=192.168.1.50,1433;Encrypt=yes;TrustServerCertificate=yes; Use code with caution. 3. Test Outside Zabbix Using isql

ybcnyc. Junior Member. Joined: Jun 2022. Posts: 1. MSSQL monitoring - MSSQL: Failed to fetch info data (or no data for 30m) 16-06- Microsoft SQL monitoring and integration with Zabbix zabbix mssql failed to fetch info data -or no data for 30m-

The Zabbix monitoring user needs specific permissions to gather performance data. Missing these will cause data fetching to fail even if the connection is established. Driver=ODBC Driver 17 for SQL Server;Server=192

Zabbix templates rely on user-defined macros to adapt to different environments. The most frequent configuration errors involve the $MSSQL.INSTANCE macro. If this macro is set incorrectly, the JSONPath queries used to extract data from the performance counters will fail because they will be looking for the wrong instance name. This typically results in "Preprocessing failed" errors for dependent items, as the data exists but Zabbix cannot find it using the provided path. Junior Member

Complex discovery scripts timing out due to high database load. Step-by-Step Troubleshooting Guide

: In mssql.conf , define your connection sessions clearly: Plugins.MSSQL.Sessions. .Uri=sqlserver:// :1433 .

# /etc/zabbix/zabbix_agentd.d/mssql.conf