The permissions for master and msdb databases are critical for the discovery rules and performance counters to function correctly.
: Verify that your macros or DSN settings are correct.
Sometimes, it’s not an error. A development SQL Server with no active databases, no user connections, and auto_close = ON will show zero for User Connections and Batch Requests/sec – resulting in “no data for 30m” because the trend function expects a positive delta. zabbix mssql failed to fetch info data -or no data for 30m-
: The Zabbix monitoring user must have specific permissions to access system views. Ensure the user has VIEW SERVER STATE VIEW SERVER PERFORMANCE STATE for MSSQL 2022) and VIEW ANY DEFINITION permissions.
Problem: MSSQL: Failed to fetch info data (or no data for 30m) The permissions for master and msdb databases are
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.
: Always restart the Zabbix Agent 2 service after making changes to plugin configurations. A development SQL Server with no active databases,
If any returns empty, debug before production.