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

mssql-cli -S <MSSQL_server_IP> -U <Zabbix_monitoring_account> -P <password>

Zabbix requires low-level system view authorizations to assemble database state payloads. Standard SQL logins will fail silently or trigger data fetch alerts if they lack global access.

Or better (Windows):

UserParameter "db.mssql.ping" returned value "1" zabbix mssql failed to fetch info data -or no data for 30m-

Then from (as the Zabbix agent service account):

# Open ODBC Data Source Administrator (64-bit) C:\Windows\System32\odbcad32.exe

Locate your zabbix_agent2.conf file.

If isql works, your macros are correct, and the user has the right permissions, but you still get "no data," the issue is often more subtle and lies in how the template's preprocessing rules interact with your specific SQL Server instance.

zabbix_get -s <SQL_HOST_IP> -k "agent.ping"

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; If isql works, your macros are correct, and

: Ensure the odbc.ini file does not store credentials. For Zabbix, username and password should be passed as arguments from the frontend.

What appears when you hover over the red "info" icon next to the item in Zabbix?

When using Zabbix Agent 2, the mssql.conf plugin file must be present in the plugins.d directory, and the agent must be restarted to load it. What appears when you hover over the red

If isql throws an error regarding encryption or certificates, you may need to append TrustServerCertificate parameters to your Zabbix connection macros. For ODBC Driver 18, set: TrustServerCertificate=yes;Encrypt=yes; Use code with caution. 3. Enable TCP/IP Protocols in SQL Server

If you are using the , the Zabbix server or proxy must have the correct ODBC drivers installed and configured. Steps to Fix: