September 2010
Intermediate to advanced
1704 pages
111h 8m
English
A networking feature in SQL Server 2008 adds an additional layer to the client/server network structure: Tabular Data Stream (TDS) endpoints. When you install (or upgrade to) SQL Server 2008, a default system endpoint is created on the server for each available protocol on the server. These endpoints cannot be dropped, and they are created regardless of whether the protocol is disabled or otherwise unavailable.
The term endpoint in this context refers to the combination of a protocol selection, one or more IP addresses (or pipe names), and any associated port numbers.
These are the default system endpoints:
• TSQL Local Machine (for shared memory)
• TSQL Named Pipes
• TSQL Default TCP
• TSQL Default VIA
• Dedicated ...