“Failed to fetch info data from database.”
UserParameter=perf.mssql[fetch.status], /usr/local/bin/check_mssql_fetch.sh
The monitoring user must have VIEW SERVER STATE (for SQL 2017/2019) or VIEW SERVER PERFORMANCE STATE (for SQL 2022). zabbix mssql failed to fetch info data -or no data for 30m-
If your SQL Server instance uses a non-default port, specify it after a comma in the Server line, like Server = 192.168.1.100, 14330 .
: MSSQL named instances often use dynamic ports. Ensure your DSN or macro includes the correct port (e.g., Server = 192.168.1.1,1433 ). 1. Fix Connection & Driver Issues “Failed to fetch info data from database
:
Troubleshooting Zabbix: MSSQL Failed to Fetch Info Data / No Data for 30m Ensure your DSN or macro includes the correct port (e
If isql throws an error regarding encryption or certificates, you may need to append TrustServerCertificate parameters to your Zabbix connection macros. For ODBC Driver 18, set: TrustServerCertificate=yes;Encrypt=yes; Use code with caution. 3. Enable TCP/IP Protocols in SQL Server
Example:
or Zabbix macros, the port must be specified after a comma, not a colon (e.g., Server = 192.168.1.50,1433 as a separate directive often fails. Macro Configuration : Verify that your host macros are correctly set: $MSSQL.USER $MSSQL.PASSWORD $MSSQL.DSN (must match the name in your /etc/odbc.ini on the Zabbix server/proxy). Agent 2 Configuration
Problem: MSSQL: Failed to fetch info data (or no data for 30m)