MS SQL database failes to connect after upgrade to 12.1SP1
search cancel

MS SQL database failes to connect after upgrade to 12.1SP1

book

Article ID: 378561

calendar_today

Updated On:

Products

Autosys Workload Automation

Issue/Introduction

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.

Environment

Autosys 12.1.01
Microsoft Windows Server 2019 Datacenter 

Cause

the environment required a change to the ODBC driver section of the config file.

Resolution

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};

Additional Information

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