Automic recommends using SQL Server Authentication

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Error Message :
N/A

Automic recommends using SQL Server Authentication. 

For more information on as to why the SQL Authentication is recommended, see the below referenced product documentation.

Reference:

Documentation - AWA Guides 12.0:
Installation Guide > Installing the Automation Engine > New Installation > MS SQL Server

 

Environment

OS: Windows
OS Version: N/A

Cause

Cause type:
Other
Root Cause: Using SQL Server authentications is easier to setup and maintain, so that is why it is recommended.

Resolution

There is no technical reason for this recommendation.

The reason is just that it requires less work and is much easier to setup.  There is at least one downside for using Windows Authentication which is that domain accounts most likely are limited on password duration.  For example, after 90 days the Automation Engine will not work because the password has expired.  One way around that limitation would be to have the domain administrator set the account to never expire.

Fix Status: No Fix

Fix Version(s):
N/A

Additional Information

Workaround :
N/A