# /etc/zabbix/zabbix_agentd.d/mssql.conf
if [ $? -eq 0 ]; then echo 0 # Success else echo 1 # Failed fi
The Zabbix Agent runs as SYSTEM (or a local user), but SQL Server restricts access to Dynamic Management Views (DMVs) like sys.dm_os_performance_counters .
: 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.