1.4 Relationship to Other Protocols

The Tabular Data Stream (TDS) protocol depends upon a network transport connection being established prior to a TDS conversation occurring (the choice of transport protocol is not important to TDS). TDS depends on Transport Layer Security (TLS)/Secure Socket Layer (SSL) for network channel encryption. Although the TDS protocol depends on TLS/SSL to encrypt data transmission, the negotiation of the encryption setting between the client and server and the initial TLS/SSL handshake are handled in the TDS layer.

If the Multiple Active Result Sets (MARS) feature [MSDN-MARS] is enabled, then the Session Multiplex Protocol (SMP) [MC-SMP] is required.

This relationship is illustrated in the following figure.

Protocol relationship

Figure 2: Protocol relationship