TDS is a protocol that describes the rules for how data is transferred between two computers. Like other protocols, it defines the type of transmission information and the order in which they are transmitted. In short, the protocol describes "bits on the line", that is, how data flows. The Tabular Data flow protocol is based on TCP/IP net-library and is included in the TCP data segment. TDS uses port 1433 for database communication.
The TDS protocol is located within the TCP data segment, and is structured as follows:
Ip |
Tcp |
TDS Header |
Data segment of TDS |
8-digit Head
The TDS client uses SQL Server-specific application-level protocols called tabular Data Stream (TDS) to send SQL statements. The packet is generated by the Microsoft OLE DB provider, SQL Server ODBC driver, or db-library DLL for SQL Server. TDS packets are then passed to the SQL Server client net-library, and the client net-library encapsulates the TDS packet as a network protocol packet. On the server, the server net-library receive the network protocol packets and extract the TDS packets and pass them to the relational database server. This process is reversed when the result is returned to the client.