Unable to start BPM server due to “DSRA0010E: SQL State = 08S01, Error Code = 0” during SSL handshake

After applying some Windows Security on a remote Microsoft SQL Server node, BPM 8.5.5.0 failed to start caused by SSL/TLS connection errors.

Error 1:

Caused by: com.ibm.websphere.ce.cm.StaleConnectionException:
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: XXXXXX”.
DSRA0010E: SQL State = 08S01, Error Code = 0

Error 2:

FFDC
Exception:com.microsoft.sqlserver.jdbc.SQLServerException
SourceId:com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledCon ProbeId:1298
com.microsoft.sqlserver.jdbc.SQLServerException:
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: XXXXX”.
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)
Caused by: java.io.IOException: SQL Server did not return a response.
The connection has been closed.
ClientConnectionId:98120ce4-9530-4aa1-9ffd-7906e6901613
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.ensureSSLPayload(IOBuffer.java:651)
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.readInternal(IOBuffer.java:708)
at com.microsoft.sqlserver.jdbc.TDSChannel$SSLHandshakeInputStream.read(IOBuffer.java:700)
at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.readInternal(IOBuffer.java:895)
at com.microsoft.sqlserver.jdbc.TDSChannel$ProxyInputStream.read(IOBuffer.java:883)
at com.ibm.jsse2.b.a(b.java:20)
at com.ibm.jsse2.b.a(b.java:44)
at com.ibm.jsse2.SSLSocketImpl.a(SSLSocketImpl.java:601)
at com.ibm.jsse2.SSLSocketImpl.h(SSLSocketImpl.java:39)
at com.ibm.jsse2.SSLSocketImpl.a(SSLSocketImpl.java:656)

Environment

– IBM Business Process Manager Advanced 8.5.5.0
– IBM WebSphere Application Server Network Deployment 8.5.5.2
– IBM Java SDK 6.1.7.1 pwa6460_26sr7fp1ifx-20140220_01 (SR7 FP1)
– Microsoft Windows Server 2012 R2 Datacenter
– Microsoft SQL Server 2012 v11.0.3000.0

Related:

Leave a Reply