IBM Support

Optim Connection Manager is unable to properly connect to an SQL Server database when adding an Optim Directory

Question & Answer


Question

Why can't the Optim Connection Manager properly connect to an SQL Server database while adding an Optim Directory?

The WAS CE log will show the below error. 
java.io.IOException: SQL Server did not return a response. The connection has been closed. ClientConnectionId:e40a0760-f491-43e7-bc2d-32695faaeab7 
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.ensureSSLPayload(IOBuffer.java:711) 
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.readInternal(IOBuffer.java:768) 
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.read(IOBuffer.java:760) 
at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.readInternal(IOBuffer.java:955) 
at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.read(IOBuffer.java:943) 
at com.ibm.jsse2.b.a(b.java:240) 
at com.ibm.jsse2.b.a(b.java:142) 
at com.ibm.jsse2.at.a(at.java:630) 
at com.ibm.jsse2.at.i(at.java:509) 
at com.ibm.jsse2.at.a(at.java:259) 
at com.ibm.jsse2.at.startHandshake(at.java:392) 
at com.microsoft.sqlserver.jdbc.TDSChannel.enableSSL(IOBuffer.java:1688) 

[{"Product":{"code":"SSMLQ4","label":"IBM InfoSphere Optim Test Data Management Solution"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"11.3.0","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 July 2021

UID

swg22015748

Page Feedback