Zabbix Mssql Failed To Fetch Info Data -or No Data For 30m- _verified_ (PREMIUM)
: If you are using a self-signed certificate, you may need to add TrustServerCertificate=Yes or use the flag if testing with $MSSQL.USER $MSSQL.PASSWORD
In your Zabbix server, add a log item:
: Test the connection manually from the command line on the Zabbix server or proxy using isql or sqlcmd to rule out Zabbix-specific issues: isql -v zabbix mssql failed to fetch info data -or no data for 30m-
Example good log:
On the SQL Server, open → System DSN → Create a test DSN pointing to your instance. : If you are using a self-signed certificate,
: 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 VIEW ANY DEFINITION