I am running Zabbix 6.4.9 on Ubuntu 22.04.3 LTS. I am connecting to a Windows 2019 server running Microsoft SQL Server 2019. I have the Microsoft ODBC driver version 17 installed on the zabbix server, and I have the odbc.ini configured per the instructions for each database I wish to connect to. I am able to connect successfully with isql, and I can query metrics like log filesize successfully with the credentials Zabbix uses:
When I load the template and macros into the host, I get some of my performance metrics, but not most of them. Mostly it is issues with file sizes and performance metrics:
I believe the accounts are set up correctly; I followed the guide for the official template exactly: https://www.zabbix.com/integrations/mssql
My question is, is something wrong with the template? Is there a permissions issue on the account...that doesn't make sense as I can query specific things like log file size directly. Any advice is appreciated.
When I load the template and macros into the host, I get some of my performance metrics, but not most of them. Mostly it is issues with file sizes and performance metrics:
I believe the accounts are set up correctly; I followed the guide for the official template exactly: https://www.zabbix.com/integrations/mssql
My question is, is something wrong with the template? Is there a permissions issue on the account...that doesn't make sense as I can query specific things like log file size directly. Any advice is appreciated.