Problem: MSSQL: Failed to fetch info data (or no data for 30m)
Zabbix MSSQL templates utilize PowerShell scripts to query WMI and SQL management objects. By default, Windows Server restricts script execution. zabbix mssql failed to fetch info data -or no data for 30m-
Ensure the Microsoft ODBC Driver for SQL Server is properly installed. B. Validate Zabbix Agent2 MSSQL Access (Windows/Linux) If using Zabbix Agent2, it connects directly to MSSQL. Problem: MSSQL: Failed to fetch info data (or
Once you correct the permissions or
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 Understanding the Error The user must have VIEW
The user must have VIEW SERVER STATE and VIEW ANY DEFINITION permissions on the MSSQL instance. C. Check Network and Firewall The default MSSQL port is TCP 1433. Telnet/NC Test: From the Zabbix Proxy/Server, run: nc -zv 1433 Use code with caution.