The SNI protocol layer is common to both the Database Engine ("Server") and SQL Server Native Client ("Clients"). SQL Server Network Interface (SNI) protocol layer encapsulates the TDS packet inside a standard communication protocol such as TCP/IP. In addition, TDS does not make any assumption about the transport protocol used, but it does assume the transport protocol supports reliable, in-order delivery of the data.Ī TDS data stream can span multiple network data packets. It persists until the transport-level connection is terminated (for example, when a TCP socket is closed). The TDS session is directly tied to the transport-level session, meaning that a TDS session is established when the transport-level connection is established and the server receives a request to establish a TDS connection.
Once the connection is established using a transport-level protocol, TDS messages are used to communicate between the client and the server. TDS Protocol does transfer of requests and responses between Clients and Database Servers, where the Client will typically establish a long-lived connection with the server. Invocation of a stored procedure or user-defined function, also known as a remote procedure call (RPC). Specification of requests in SQL (including Bulk Insert). Authentication and channel encryption negotiation. The Tabular Data Stream (TDS) protocol is an application layer request/response protocol that facilitates interaction with a database server and provides for the following:
0 kommentar(er)
