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

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

book

Article ID: 379109

calendar_today

Updated On:

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.