After upgrade of AutoSys from R12.1 to R12.1 SP1, the AutoSys Application Server and Scheduler fail to connect to the database. The as_server and event_demon logs show the following error:
[09/27/2024 17:08:18] CAUAJM_I_40275 Log Rollover level set to <MIDNIGHT,SIZE(100),PURGE(7)>.
[09/27/2024 17:08:18] CAUAJM_I_40244 EnableIPCaching value set to <1>.
[09/27/2024 17:08:18] CAUAJM_I_40244 LogMaxEndLines value set to <2,000>.
[09/27/2024 17:08:18] CAUAJM_I_10655 System is running in single server mode. Event server: <hostname>.<example>.com,1433:<databasename>
[09/27/2024 17:08:18] CAUAJM_E_18600 Database function call <SQLDriverConnect> failed in <connect SQLDriverConnect Failed> with return code: -1
[09/27/2024 17:08:18] CAUAJM_E_18601 SQLSTATE: IM008, Native error: 0, Message: [Microsoft][ODBC Driver Manager] Dialog failed
[09/27/2024 17:08:18] CAUAJM_E_10649 Server <hostname>.<example>.com,1433:<databasename> was not available during connection operation.
AutoSys 12.x
A change to the MSSQLDriverConnString section of the AutoSys config file is needed.
MSSQLDriverConnString
in that file and change it:From:MSSQLDriverConnString={ODBC Driver 17 for SQL Server}
To:MSSQLDriverConnString=DRIVER={ODBC Driver 17 for SQL Server};
Below are additional tags that can be used to help deal with SSL configuration issues.MSSQLDriverConnString=DRIVER={ODBC Driver 17 for SQL Server};TrustServerCertificate=No;Encrypt=No