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

The most common culprit is a broken ODBC path. If you recently updated your Zabbix server, the driver version might have changed.

: Ensure the Zabbix monitoring user has the following permissions on the MSSQL instance: VIEW SERVER STATE (for 2017/2019) or VIEW SERVER PERFORMANCE STATE (for 2022). VIEW ANY DEFINITION Access to the database for job monitoring. Correct Connection Syntax

Look for status = 'suspended' (blocked) or running for hours. zabbix mssql failed to fetch info data -or no data for 30m-

Run this script on your SQL Server to ensure the Zabbix user has the minimum required access:

Before adding the host to Zabbix, run this PowerShell script to validate all metrics: The most common culprit is a broken ODBC path

Switch to sys.dm_db_resource_stats or sys.server_resource_stats views. Customize the user parameter to query these instead. The official Zabbix template for Azure SQL Database is different from on-prem MSSQL.

The most effective way to resolve this "no data" error is to use in your configuration. This bypasses common connection issues by explicitly defining the URI and credentials in the plugin configuration. VIEW ANY DEFINITION Access to the database for

Get-Item: Cannot find path '...' because it does not exist. OR AuthorizationManager check failed.