Zabbix Agent2 MSSQL login issue

[rthonpm]

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?

[irontmp]

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, and much like troubleshooting a honista old version compatibility issue it sometimes comes down to permission inheritance. 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?

Run gpresult /h report.html on the problem server and compare it to a working one, a missed group policy is the most likely culprit since the agent never even attempts login. Also check Windows Event Viewer under Security and Application logs for any permission errors related to the Zabbix agent process. Then try running the mssql plugin manually from command line using the domain credentials to see if it throws any errors before SQL login even happens.