Installation of UIM connector support for SQL server 2016

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

Unable to install UIM connector due to the following pop-up error 
Invalid CA Unified Infrastructure Management Database Information is invalid. 

Error: DB Connection Failure - 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. 

Catalyst_TemplateConnector_InstallDebug.log 

Validating UIM Database connection. 
in install : NSSystemValidator 
Inside validate 1 :: DB username : ****, hub username : 
Inside validate 2 :: run time jar location : , URL generated on the fly is ********* : jdbc:sqlserver://****:1433;databaseName=CA_UIM;, input.wsUsername : **** databaseType:"Microsoft SQL Server","","" 
validating database as values changed. 
Inside validate with user input ::****, ,"Microsoft SQL Server","","" 
Mar 19, 2019 12:07:07 PM com.microsoft.sqlserver.jdbc.TDSChannel enableSSL 
INFO: java.security path: C:\Users\****\AppData\Local\Temp\3\I1553018568\Windows\resource\jre\lib\security 
Security providers: [SUN version 1.7, SunRsaSign version 1.7, SunEC version 1.7, SunJSSE version 1.7, SunJCE version 1.7, SunJGSS version 1.7, SunSASL version 1.7, XMLDSig version 1.0, SunPCSC version 1.7, JsafeJCE version 3.6] 
SSLContext provider info: Sun JSSE provider(PKCS12, SunX509 key/trust factories, SSLv3, TLSv1) 

java.ext.dirs: C:\Users\****\AppData\Local\Temp\3\I1553018568\Windows\resource\jre\lib\ext;C:\Windows\Sun\Java\lib\ext 
error closing connection 
com.ca.NimsoftConnector.installer.NSSystemValidationError: DB Connecction Failure - 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. ClientConnectionId:5679c246-4483-406c-8cf0-64e4fb0bb5a0". 
 

Environment

SOI 4.2 
UIM 9.02 with SQL 2016 
UIM Connector 3.9.32 
Windows 2016 

Cause

Windows registry SecurityProviders key on the Database Server. 
TLS setting in the registry. 
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.0] 
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.1] 
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2] 
 

Resolution

When you encounter the error during the installation, just click on "Continue Anyway" and complete the install. When the connector starts, it will be able to connect to the UIM DB.