SQL agent job fails with login error "trigger execution" on Automic V21

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The database driver returned the following error message on the agent log.

2024-09-26 19:46:24 - U02012031 The database driver returned the following error message:
2024-09-26 19:46:24             Logon failed for login 'AUTOMIC_app' due to trigger execution. 

Environment

Automic V21 and higher

Cause

configuration

Resolution

After downgrading the MySQL jar to a lower version the issue is resolved.

Downgraded the SQL JDBC from sqljdbc_12 to sqljdbc_9.

 

Additional Information

Note: Validate the driver version, which is located at the jdbc folder and that the auth_dll is in the bin directory.