search cancel

WAAE database was not created or updated when using Windows Authentication.


Article ID: 185743


Updated On:


CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - System Agent (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent CA Workload Automation AE


While installing Workload automation AE we see a warning that AE database was not created or updated when using "Windows Authentication".


Release : 11.3 Plus version on Windows

Component : CA Workload Automation AE (AutoSys)


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.


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:
Step 1: sqlcmd -E -S DBautosysDB01,1433 -d master -m 11 -e
Step 2: At the prompt type the below query, if it fails you need to work with the DBA to get proper DBA privileges. 
create login testlogin with password='testlogin', check_expiration=off, check_policy=off

Additional Information

In case of any issues, please raise a case to support.