EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB442353: SQL Server Wire Protocol driver SSL Handshake Failure reason error


Edgar Garcia Rosas

Senior Technical Account Manager I • MicroStrategy


This is an SSL handshake failed error when multiple parallel connections were made using SQL Server Wire Protocol driver.

SUMMARY
When connecting to Microsoft SQL Server Databases with SSL an error or set of errors similar to the ones below will be recorded in the DSSErros log or shown in a dialog box while using a graphical user interface:


...[Database Classes][Error] Failed to connect to data source. Error message: Connect failed.

...[Database Classes][Error] Connect failed.
Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [08S01:0: on SQLHANDLE] [Strategy][ODBC SQL Server Wire Protocol driver]Socket closed. [08001:7570: on SQLHANDLE] [Strategy][ODBC SQL Server Wire Protocol driver]SSL Handshake Failure reason [Unknown SSL Error]. Connection String...

This is an SSL handshake failed error when multiple parallel connections were made using SQL Server Wire Protocol driver.
CAUSE
In one of the packet, it was identified by the ODBC driver provider that driver was sending an incorrect PRELOGIN(0x12) packet with different header/payload size which causes the SSL handshake failure:
THE SSL HANDSHAKE FAILED ERROR WHEN MULTIPLE PARALLEL CONNECTIONS WERE MADE USING SQL SERVER WIRE PROTOCOL DRIVER
Confirming the SQL Server Wire Protocol driver version present:
Windows
1.-Go to the following directory path:

C:\Program Files (x86)\Common Files\MicroStrategy\ODBC

2.-Look for the following file then make a right click on Properties:
mysqls64.dll
3.-Go to the Details Tab to check the version at "Product version".
Linux
1.-Using the terminal to the following directory path:

/opt/MicroStrategy/lib/

2.-The following file must be present:
MYsqls64.so
3.-Execute the following statement to obtain the version information:

strings MYsqls64.so | grep -m 1 -e '[0-9]*[1-9]\.[0-9]\+\.[0-9]\+\.[0-9]\+' -e '[0-9]*[1-9]\.[0-9]\+\.[0-9]\{4\}'

ACTION
If in Strategy 10.4, please make sure to apply at least Hotfix 6 which is shipped with the SQL Server Wire Protocol driver version 07.16.0355.
If in Strategy feature release, please make to upgrade at least to Strategy 10.10 which is shipped with the SQL Server Wire Protocol driver version 07.16.0355.
Article Reference Number: KB442353


Comment

0 comments

Details

Knowledge Article

Published:

December 5, 2018

Last Updated:

January 4, 2019