The Zabbix server, proxy, or agent logs will provide the specific reason for the failure.
Before diving into the troubleshooting steps, it's essential to understand the possible causes of these errors: zabbix mssql failed to fetch info data -or no data for 30m-
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. The Zabbix server, proxy, or agent logs will
odbc: SQLExecDirect: retcode=-1 (42S02: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Invalid object name 'sys.dm_os_performance_counters'.) If you share with third parties, their policies apply
If the connection times out, check Windows Firewall on the database server or your cloud network security groups (NSGs) to ensure port is open from the Zabbix IP source.
Connect to your SQL Server instance via SQL Server Management Studio (SSMS) and execute the following script to grant the necessary rights to your Zabbix login:
