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

: Verify you have installed the zabbix-agent2-plugin-mssql package or the equivalent Windows plugin. 5. Debugging "No Data"

When this trigger fires, the monitoring chain is broken at one of three levels: , Connectivity , or Configuration .

This is a common, known issue. If your SQL Server is a named instance (e.g., MSSQL$MYINSTANCE ), the performance counter object names might be structured as MSSQL$MYINSTANCE:Buffer Manager . The template's JSONPath queries might be looking for SQLServer:Buffer Manager , which is for a default instance.

$MSSQL.DSN : Ensure this matches the Data Source Name configured in your /etc/odbc.ini file. If you are using a DSN-less connection, leave this macro empty and rely on the connection string. zabbix mssql failed to fetch info data -or no data for 30m-

When Zabbix triggers or "No data for 30m" , the root cause is rarely the same. The former suggests an authentication or query execution failure; the latter suggests timeouts, deadlocks, or connectivity intermittency.

This public link is valid for 7 days and shares a thread, including any personal information you added. This link or copies made by others cannot be deleted. If you share with third parties, their policies apply. Can’t copy the link right now. Try again later.

: If using newer ODBC drivers (v18+), encryption is often forced. Try adding TrustServerCertificate=yes or Encrypt=yes to your connection string or odbc.ini file. This is a common, known issue

Additionally, if the template uses the msdb database, grant specific permissions:

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

To avoid encountering these errors in the future, follow these best practices: $MSSQL

: In mssql.conf , define your connection sessions clearly: Plugins.MSSQL.Sessions. .Uri=sqlserver:// :1433 .

USE msdb; CREATE USER zbx_monitor FOR LOGIN zbx_monitor; GRANT SELECT ON msdb.dbo.sysjobs TO zbx_monitor; GRANT SELECT ON msdb.dbo.sysjobservers TO zbx_monitor; GRANT SELECT ON msdb.dbo.sysjobactivity TO zbx_monitor; GRANT EXECUTE ON msdb.dbo.agent_datetime TO zbx_monitor;

The "Failed to fetch info data" error is rarely a problem with Zabbix itself; instead, it points to authentication restrictions, unconfigured network protocols, or strict driver encryption rules. Granting VIEW SERVER STATE permissions and verifying connections via command-line utilities like isql will resolve the majority of monitoring gaps, restoring stable, 24/7 visibility into your database environment.