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

Products

• 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

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:

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

go

Additional Information

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