Zabbix Mssql Failed To Fetch Info Data -or No Data For 30m- [Android Complete]

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

-- For SQL Server 2017, 2019, 2022 USE master; CREATE LOGIN zabbix WITH PASSWORD = 'YourStrongPassword'; GRANT VIEW SERVER STATE TO zabbix; GRANT VIEW ANY DEFINITION TO zabbix; -- For MSDB connectivity USE msdb; CREATE USER zabbix FOR LOGIN zabbix; GRANT EXECUTE ON msdb.dbo.agent_datetime TO zabbix; GRANT SELECT ON msdb.dbo.sysjobactivity TO zabbix; GRANT SELECT ON msdb.dbo.sysjobservers TO zabbix; GRANT SELECT ON msdb.dbo.sysjobs TO zabbix; GO Use code with caution. 2. Root Cause: ODBC Driver Misconfiguration (ODBC Template)

$MSSQL.DRIVER : Ensure the driver name exactly matches the string in /etc/odbcinst.ini (e.g., ODBC Driver 18 for SQL Server ). zabbix mssql failed to fetch info data -or no data for 30m-

Note: If using the MSSQL plugin directly, you can also look for Plugins.MSSQL.Timeout=15 inside the configuration file. For Zabbix Server or Proxy:

<item name="MSSQL: Last successful fetch" key="msql.last.success.time"> <type>Zabbix agent</type> <key>perf.mssql[last_success]</key> <value_type>Numeric (unsigned)</value_type> <units>unixtime</units> <delay>60s</delay> </item> MSSQL: Failed to fetch info data (or no

If manual fails, the issue is OS/ODBC layer.

Check the Zabbix Agent logs on the Windows MSSQL host ( C:\Program Files\Zabbix Agent\zabbix_agentd.log ). You will likely see: Note: If using the MSSQL plugin directly, you

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

: The monitoring user must have specific rights to view server state and access the . Use the following T-SQL to grant required permissions: GRANT VIEW SERVER STATE TO [zabbix_user] VIEW SERVER PERFORMANCE STATE for SQL 2022+) GRANT VIEW ANY DEFINITION TO [zabbix_user] Read access to msdb.dbo.sysjobs msdb.dbo.sysjobservers msdb.dbo.sysjobactivity Zabbix Git repository ODBC Configuration Issues (ODBC Template) Port Formatting

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

If this fails, your issue lies in /etc/odbc.ini or /etc/odbcinst.ini , or you are missing the Microsoft ODBC Driver for SQL Server on your Zabbix server/proxy. Summary Checklist Action Item Verification Command / Location Zabbix Frontend > Host > Macros Verify Port nc -zv 1433 Check DMVs GRANT VIEW SERVER STATE TO ... in SSMS Boost Timeout Timeout=15 in Zabbix config files Test Agent Directly zabbix_agent2 -t mssql.info.data[...]