Automic recommends using SQL Server Authentication

Document ID : KB000085118
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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