[AWA] DB jobs error com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset

book

Article ID: 106381

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

Issue/Introduction

Several DB jobs ends with the error com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset.
What can be causing this?

Environment

Release:
Component: AAUTEN

Resolution

It look like a network issue or the compatible of your JDBC driver and your MSSQL server.
You should check with the DBA on the version of the Microsoft JDBC driver that is suitable with your SQL Server database.
If needed, you should update the JDBC driver accordingly.

Additional Information

JDBC driver version for each Database type can be found here.