The Runtime fails to connect to SSL enabled MDB database

Products

• CA Service Management - Service Desk Manager
• CA Service Desk Manager

Issue/Introduction

 SDM Remote MDB installation failed with exitCode:3

The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "SQL Server did not return a response. The connection has been closed.

Environment

Release: 17.+

Components: MSSQL mdb

Cause

The server administrator configured the server's security protocols using a cryptographic program from third-party security software, which requires matching cipher settings from connecting clients.

Resolution

The customer modified and reapplied their security product's template by adhering to their security best practices for its Cipher Suites security setting.  The security product is not owned or supported by Broadcom in order to allow a secure connection to be established with the MDB server.

Please see Additional Information for a sample security configuration.

Additional Information

The following are taken from a 3rd party security product that describes the specific settings that had been used to allow SDM to operate

Cipher Suites

Protocols and Hashes