ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

MSSQL Agent driver location

book

Article ID: 196662

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic Workload Automation - Automation Engine

Issue/Introduction

Automic Admin updated the DB Agent's .ini file to type=MSSQL. However, when I run the job the get the following error:

2020-08-03 12:40:17 - U02012031 The database driver returned the following error message:
2020-08-03 12:40:17 java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

 

Environment

Release : 12.3

Component : AUTOMATION ENGINE

Resolution

In our documentation we give you the direct links to the drivers:

https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Installation_Manual/InstallAgents/InstallAgentDatabase_JobsEvents.htm

Nonetheless, that driver would be installed to:

..../sql/bin/jdbc directory

 

Additional Information

Note:  Your MSSQL Agent can be installed on Linux/Unix because we use a JDBC driver.