Automic recommends using SQL Server Authentication

book

Article ID: 85118

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION

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


 

Cause

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

Environment

OS: Windows
OS Version: N/A

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