Testing a MS SQL Server connection object with integratedSecurity = true crashes the DB service agent.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
EXCEPTION_ACCESS_VIOLATION (0xc0000005) at pc=0x000000006f56e853, pid=2496, tid=0x00000000000013f0

Testing a SQL Server connection object with integratedSecurity = true (Windows authentication) crashes the DB Service agent.

 

 

Environment

OS: Windows
OS Version: Windows Server 2012 R2, Windows Server 2016

Cause

Cause type:
Configuration
Root Cause: SQL JDBC driver version 6.0 is causing this behavior.

Resolution

Download MS SQL JDBC driver version 6.2.2.

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
Do not use Windows authentication. Just use SQL server authentication.