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.

Was this topic helpful?

Document Information

More support for:
IBM InfoSphere Optim Test Data Management Solution

Software version:
11.3.0

Operating system(s):
AIX, Linux, Solaris, Windows

Document number:
569921

Modified date:
08 July 2021

UID

swg22015748

IBM Support

Tips