Microsoft® SQL Server 2008 R2 Unleashed

The AS HTTP Keyword Group

The AS HTTP statements describe the protocol, ports, virtual path, and TCP/IP bindings for the endpoint. This keyword group is of interest to security professionals because this is where you can implement IP restrictions, authentication, and other lockdown mechanisms.

In the example shown in Listing 48.3, HTTP is the transport protocol. But you could just as easily use TCP if your application demands it: when creating a TCP endpoint, you specify AS TCP instead of AS HTTP. Then you add the following parameters:

• LISTENER_PORT—Specifies an integer-valued port number on which the server listens for incoming requests. The default is 4022.

• LISTENER_IP—Specifies an incoming IP address on which the TCP listener accepts ...