My Oracle Support Banner

Unable to Connect to SSL Enabled SQL Server from RPD (Doc ID 2837243.1)

Last updated on JANUARY 31, 2022

Applies to:

Oracle Analytics Server - Version 5.9.0 and later
Information in this document applies to any platform.

Symptoms

Analysis that are running against SSL enabled SQL Server Database fail with below
View Display Error


[2022-01-11T13:54:06.378-08:00] [OBIS] [ERROR:1] [] [] [ecid: 43a439b3-5720-48b6-b5aa-8cab30c9007e-0000ac9e,0:2:83:5:1:1] [sik: ssi] [tid: ef6f6700] [nQSError: 16001] ODBC error state: 08S01 code: 0 message: [Oracle DataDirect][ODBC SQL Server Wire Protocol driver]Socket closed.. [[
file: server/Query/Execution/DbGateway/Odbc35/../Odbc/Src/SQXDGOdbcConnection.cpp; line: 1151
Properties: description=<<33486>> DbGateway Exchange: eRSP.conn_eRSP; producerID=0xee6b85c8; requestID=0x5bfb0016; sessionID=0x5bfb0000; userName=nmeher;
[nQSError: 16028] ODBC error state: 08001 code: 7570 message: [Oracle DataDirect][ODBC SQL Server Wire Protocol driver]SSL Handshake Failure reason [Unknown SSL Error]..

Changes

Enabled SSL for SQL Server.

None SSL Connection to SQL Server works fine.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.