WAAE database was not created or updated when using Windows Authentication.
book
Article ID: 185743
calendar_today
Updated On:
Products
CA Workload Automation AE - Business Agents (AutoSys)CA Workload Automation AE - System Agent (AutoSys)CA Workload Automation AE - Scheduler (AutoSys)Workload Automation AgentCA Workload Automation AE
Issue/Introduction
While installing Workload automation AE we see a warning that AE database was not created or updated when using "Windows Authentication".
Environment
Release : 11.3 Plus version on Windows
Component : CA Workload Automation AE (AutoSys)
Cause
Its due to lack of permission for the user.
sqlcmd -E -S DBautosysDB01,1433 -d master -m 11 -e -i create_autosys.sql 2>&1 create login autosys with password='xxxxxxx', check_expiration=off, check_policy=off Msg 15247, Level 16, State 1, Server DBautosysDB01, Line 1 User does not have permission to perform this action. Cleanup is entered. CA Workload Automation AE database was not created or updated.
Resolution
It means Windows O/S user has no permission to create autosys login in the database.
So you need to check if you can create any test login using below SQL server command: