Microsoft SQL through SSL Vserver fails

Microsoft SQL through SSL Vserver fails

book

Article ID: CTX309165

calendar_today

Updated On:

Description

When running SQL Management Studio through TCP Vserver it connects fine, but though SSL_TCP you receive a connection error.
Error:
A connection was successfully established with the server, but then an error occurred during the pre-login handshake.
Error: 64

Resolution

Use TCP virtual server type.

Problem Cause

Management Studio uses TDS (Tabular Data Stream) when connecting regardless of whether or not you tell it to encrypt data.  TDS always sends a pre-login packet to setup it's connection.  Netscaler is sending reset when it receives a TDS pre-login packet. This behavior is expected as the pre-login message is not SSL/TLS. Netscaler needs a client hello message to begin the TLS process.  Management Studio will use the pre-login process to setup TLS but the TLS will be within the TDS and not directly inside TCP.