Running SQL_Accesibility results in SSL errors

  • 7022771
  • 23-Mar-2018
  • 23-Mar-2018

Environment

AppManager Enterprise 9.1

Situation

Running SQL_Accessibility KS in environments with TLS 1.2 enabled causes SSL errors like below:

SQL::GetDBNAmes() exited: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error
SQL::GetDBNAmes() exited: [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.
@SQLServer\SQLInstance : SQLAvailability::GetServerReachability: exited: [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.

Resolution

Upgrade to the SQL Server module 8.2 or higher 

Cause

This is caused by TLS 1.2 being enabled in the environment,  The older SQL module does not support TLS 1.2.  In cases where TLS 1.2 is enabled, that requires upgrading to the new SQL Server module.