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

: GRANT VIEW SERVER STATE (or VIEW SERVER PERFORMANCE STATE for 2022+), VIEW ANY DEFINITION , and specific SELECT and EXECUTE rights on msdb objects. Zabbix Backend Configuration

Leila frowned. Zabbix never screamed. It whispered. And this whisper was wrong. zabbix mssql failed to fetch info data -or no data for 30m-

If the error logs suggest "Access Denied" or return null values for metrics. : GRANT VIEW SERVER STATE (or VIEW SERVER

Increase the timeout value in the Zabbix Agent configuration file. VIEW ANY DEFINITION

: If the SQL Server requires encrypted connections, you may need to add Encrypt=yes to the connection string or TrustServerCertificate=yes if you are using self-signed certificates. Agent 2 Plugin Configuration

recovery_expression: | last(/MSSQL_Template/ms.sql.fetch_success)=1 and min(/MSSQL_Template/ms.sql.fetch_success, 5m)=1

“Failed to fetch info data from database.”