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.
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...
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]
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.