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.
CAUSEIn 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 DRIVERConfirming the SQL Server Wire Protocol driver version present:Windows1.-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".
Linux1.-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\}'ACTIONIf 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