Unable to Add or Edit MRA's in Event Management When TLS 1.0 is Disabled in MS SQL.

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

When TLS 1.0 is disabled in the MS SQL server hosting the Event Management database, EM can no longer connect to the database. This prevents adding or editing Message Record Actions from the EM Console.

The SQL Server client and ODBC driver has been installed at the level that supports TLS 1.2. However, “%CAOP_F_414, Database OPEN CURSOR failure on DB_OPEN” error appears in an odbc trace when trying to open or create a Message Record in EM.

 

Environment

Release: ATSYHA99000-11.3.6-Workload Automation AE-High Availability Option
Component:

Resolution

The first step is to ensure that updated MS SQL odbc and native client drivers that support TLS 1.2 are installed on the EM Manager machine. These can be obtained from Microsoft...

ODBC Driver 11 for SQL Server
SQL Server Native Client 10

After the updated drivers are in place, the odbc configuration for EM must be modified to use the updated drivers.

Edit C:\Program Files (x86)\CA\CA_APPSW\cauodbc.ini

Modify the following lines to...

[SQL Server]
DefaultDatabase=master
ConnectionString="DRIVER=ODBC Driver 11 for SQL Server;SERVER=%CADB_SERVER%;DATABASE=%CADB_DATABASE%;UID=%CADB_UID%;PWD=%CADB_PWD%;Trusted_Connection=%CADB_TRUSTED%;"

[SQL Native Client]
DefaultDatabase=master
ConnectionString="DRIVER=SQL Server Native Client 10;SERVER=%CADB_SERVER%;DATABASE=%CADB_DATABASE%;UID=%CADB_UID%;PWD=%CADB_PWD%;Trusted_Connection=%CADB_TRUSTED%;"

The change will be in the "DRIVER=" portion for both lines.