In order to provide direct access to SQL Server from a remote network, you first need to decide the communication protocol that client applications will use to communicate with the server. In this section we are going to focus on:
Creating a native connection to SQL Server through TCP/IP
Calling SQL Server through an HTTP Endpoint
With both approaches, you must take security measures into account.
SQL Server implements its own native communication protocol when using TCP/IP, called Tabular Data Stream (TDS). Client applications must use a compatible provider (ODBC, OLE DB, or SQLNCLI) in order to transform their requests into the TDS format.
Figure 9-1 shows the minimum recommended physical ...