CA WA AutoSys Edition (AE) Scheduler and Application server services fail to start.The Scheduler log (event_demon.%AUTOSERV%) and the Application Server log (as_server.%AUTOSERV%) under %AUTOUSER%\out directory shows the following errors repeatedly.
CAUAJM_E_18600 Database function call <SQLDriverConnect> failed in <connect SQLDriverConnect Failed> with return code: -1
CAUAJM_E_18601 SQLSTATE: 42000, Native error: 4,060, Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot open database "AEDB" requested by the login. The login failed.
CAUAJM_E_10649 Server <MSSQLServerHost>,1433:AEDB was not available during connection operation.
The Microsoft SQL Server Native error / message 4060 means that the login "autosys" was unable to connect to the database AEDB. The most common causes for this error include:
We can confirm the error using the MS SQL Server command-line interface sqlcmd, like so:
C:\>sqlcmd -U autosys -P <password> -d AEDB
Msg 4060, Level 11, State 1, Server <MSSQLServerHost>, Line 1
Cannot open database "AEDB" requested by the login. The login failed.
Msg 18456, Level 14, State 1, Server <MSSQLServerHost>, Line 1
Login failed for user 'autosys'.
1. Confirm that the Microsoft SQL Server is configured with mixed-mode authentication.
2. Map the "autosys" SQL Server login to the AEDB database and grant ujoadmin role membership.
<Please see attached file for image>src="/servlet/servlet.FileDownload?file=0150c000004AK7tAAG" alt="SQL_UMAP.PNG" width="707" height="639">