To disable a user after three failed login attempts with Wazuh, you would first need to create a rule to detect failed login attempts.
https://documentation.wazuh.com/current/user-manual/ruleset/rules/custom.html
Then, you would create an active response that runs a script to deactivate the user in Active Directory when the rule for three failed logins is triggered. Wazuh's active response framework allows you to take automatic actions based on triggered rules.
Use a PowerShell script to disable the user, and make sure Wazuh can run PowerShell scripts and has the appropriate permissions to disable accounts in Active Directory.
https://documentation.wazuh.com/current/user-manual/capabilities/active-response/index.html
After configuring the rule and active response, restart the Wazuh Manager to apply the changes, and test the setup by deliberately failing the MS SQL logon as the test user three times to confirm that the account is disabled automatically.