Zabbix Mssql Failed To Fetch Info — Data -or No Data For 30m- [extra Quality]

: The Zabbix monitoring user must have specific permissions to access system views. Ensure the user has VIEW SERVER STATE VIEW SERVER PERFORMANCE STATE for MSSQL 2022) and VIEW ANY DEFINITION permissions.

Now Zabbix screamed. The silence broke. Yellow alerts turned to red. A cascade of triggers fired: Zabbix agent on MSSQL01 is unreachable , Template DB MSSQL: Lack of available memory , No data from Database for 30 minutes . zabbix mssql failed to fetch info data -or no data for 30m-

: If your server uses a self-signed certificate, you may need to include TrustServerCertificate=Yes in your odbc.ini or connection string to prevent handshake failures. : The Zabbix monitoring user must have specific

Leila frowned. Zabbix never screamed. It whispered. And this whisper was wrong. The silence broke

The "Failed to fetch info data" and "No data for 30m" errors in Zabbix's MSSQL monitoring can be frustrating, but by understanding the possible causes and following the troubleshooting steps outlined in this article, you should be able to resolve these issues. Remember to regularly review your monitoring configurations, test database connections, and monitor Zabbix agent logs to prevent these errors from occurring in the future. If you're still experiencing issues, don't hesitate to reach out to Zabbix's support community or a qualified IT professional for assistance.

$conn = New-Object System.Data.Odbc.OdbcConnection("DSN=ZabbixTest;Trusted_Connection=Yes;") $conn.Open() $cmd = $conn.CreateCommand() $cmd.CommandText = "SELECT cntr_value FROM sys.dm_os_performance_counters WHERE object_name='SQLServer:General Statistics' AND counter_name='User Connections'" $result = $cmd.ExecuteScalar() Write-Host $result

CREATE LOGIN zabbix_svc WITH PASSWORD = 'StrongPwd!'; CREATE USER zabbix_svc FOR LOGIN zabbix_svc; GRANT VIEW SERVER STATE TO zabbix_svc; GRANT VIEW ANY DATABASE TO zabbix_svc; GRANT CONNECT SQL TO zabbix_svc;