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

-- Replace 'zabbix_user' with your actual monitoring username GRANT VIEW SERVER STATE TO zabbix_user; GRANT VIEW ANY DEFINITION TO zabbix_user; USE msdb; CREATE USER zabbix_user FOR LOGIN zabbix_user; GRANT SELECT ON msdb.dbo.sysjobactivity TO zabbix_user; GRANT SELECT ON msdb.dbo.sysjobservers TO zabbix_user; GRANT SELECT ON msdb.dbo.sysjobs TO zabbix_user; GRANT EXECUTE ON msdb.dbo.agent_datetime TO zabbix_user; Use code with caution. Copied to clipboard

[FreeTDS] Description = FreeTDS Driver Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so 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- Joined: Jun 2022

If Zabbix connects but cannot execute the underlying management views (DMVs), it will fail to return info data. The Zabbix monitoring user requires specific system-level permissions to collect performance metrics. GRANT VIEW ANY DEFINITION TO zabbix_user

Change to: