After upgrading Microsoft Windows Server 2019 Datacenter from R12.1 to R12.1 SP1 the as_server and scheduler would not connect to the database.
The as_server logs and event_demon scheduler 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>.<domainname>.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>.<domainname>.com,1433:<databasename> was not available during connection operation.
Autosys 12.1.01
Microsoft Windows Server 2019 Datacenter
the environment required a change to the ODBC driver section of the config file.
To resolve this issue the config.<INSTANCEID> file needed to be updated.
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=true;Encrypt=false