I have several SQL Servers, all running the same version of MS SQL on the same operating system, with the same group policies applied to each one. I am using a domain user account to monitor each server with the username and password for the account configured as template level macros so they apply to all systems that use the template.
One server has an odd issue where it does not return any SQL Server data. Looking up latest data, it just tells me that the metrics are unknown. The mssql plugin is the same one used on the working servers and the config files all look for the plugin executable in the same location. I have confirmed in the agent's logs that the mssql plugin is present with all of the correct functions, however it never tries to log into the server. All of the working servers show the step of logging into the SQL Server with the provided account except for this one.
I have tried uninstalling Agent 2 from the server and reinstalling cleanly. Same with the plugin, including a clean config file for both with the correct information and paths. Antivirus is not blocking any Zabbix processes as the folder and subfolders for the Agent are excluded by rules. SQL Server logs do not show any failed logins for the account. I have also attempted to remove the server and database logins for the account and re-adding it with the necessary permissions.
The OS is otherwise stable, DISM and sfc have found no component store issues and no corrupted system files.
Zabbix Server and Agent 2 are both 7.0.26
Any possible ideas?
One server has an odd issue where it does not return any SQL Server data. Looking up latest data, it just tells me that the metrics are unknown. The mssql plugin is the same one used on the working servers and the config files all look for the plugin executable in the same location. I have confirmed in the agent's logs that the mssql plugin is present with all of the correct functions, however it never tries to log into the server. All of the working servers show the step of logging into the SQL Server with the provided account except for this one.
I have tried uninstalling Agent 2 from the server and reinstalling cleanly. Same with the plugin, including a clean config file for both with the correct information and paths. Antivirus is not blocking any Zabbix processes as the folder and subfolders for the Agent are excluded by rules. SQL Server logs do not show any failed logins for the account. I have also attempted to remove the server and database logins for the account and re-adding it with the necessary permissions.
The OS is otherwise stable, DISM and sfc have found no component store issues and no corrupted system files.
Zabbix Server and Agent 2 are both 7.0.26
Any possible ideas?