MSSQL Server Native Client and Microsoft ODBC Driver SQL Server

book

Article ID: 238825

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

SQL Native Client supports SQL Server only up to version 2012. Afterwards the Microsoft ODBC Driver 17 for SQL Server should be used (> SQL Server 2016).

ref: https://docs.microsoft.com/en-us/sql/relational-databases/native-client/applications/support-policies-for-sql-server-native-client?view=sql-server-ver15
 

In regards to that the Automic documentation is outdated:

https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Installation_Common/PreparationSteps/PrepareAEDB_MSSQL.htm

Cause

Documentation wrong

Environment

Release : 12.3.9

Component : AUTOMATION ENGINE

Resolution

The issue has been confirmed to be a bug and will be fixed with an update of the documentation for V12.3 and V21.0.