tester777. Junior Member. Joined: Aug 2020. Posts: 9. #1. MSSQL: Failed to fetch info data (or no data for 30m) - suggestions. 18-
Zabbix’s ODBC DSN often uses Server=localhost\INSTANCE . This requires SQL Browser (UDP port 1434) to resolve the dynamic port. If SQL Browser is disabled, the connection hangs then fails.
She watched the percentage crawl from 0 to 100. Four minutes. zabbix mssql failed to fetch info data -or no data for 30m-
GRANT VIEW SERVER STATE TO zabbix; (or VIEW SERVER PERFORMANCE STATE for SQL 2022). GRANT VIEW ANY DEFINITION TO zabbix; .
echo "SELECT 1" | isql MSSQL_DSN zbx_monitor YourStrongPassword tester777
: Ensure the monitoring user has VIEW SERVER STATE and VIEW ANY DEFINITION permissions.
Before you do anything in Zabbix, test the connection from the command line. This bypasses Zabbix entirely and isolates driver issues. Posts: 9
The permissions for master and msdb databases are critical for the discovery rules and performance counters to function correctly.
If everything is configured correctly, you should see a Connected! message followed by an SQL> prompt. If you see an error, it's usually a configuration or driver issue. Additionally, test the connection using a simple query to ensure you can fetch data: