TDS is a protocol that describes how data is transmitted between two computers. Like other protocols, it defines the types of transmission information and their transmission order. In short, the Protocol describes "online BITs", that is, how data flows. The table data stream 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 in the TCP Data Segment and has the following structure:
IP |
TCP |
TDS Header |
Data Segment of TDS |
8-bit Header
The TDS client uses a dedicated SQL Server application called table format data stream (TDS ).ProgramLevel protocol to send SQL statements. Data packets are generated by Microsoft ole db provider for SQL Server, SQL Server ODBC driver, or DB-library DLL. TDS data packets are then transmitted to the SQL Server Client net-Library. The client net-library encapsulates the TDS data packets as network protocol data packets. On the server, the server net-Library receives network protocol data packets and analyzes and transmits the data packets to the relational database server. When the result is returned to the client, the process is executed in reverse mode.