6.2. Networking

Connections to SQL Server are established using a standard network protocol such as TCP/IP. Depending on the installed edition of SQL Server, certain protocols are disabled by default. In this section, we'll look at the process of enabling and configuring network protocols. You'll learn the importance of only enabling the required protocols, configuring TCP/IP settings, protecting SQL Server behind a firewall, and encrypting network communications. Let's begin with looking at enabling and configuring network protocols.

6.2.1. Protocol selection and configuration

The following network protocols are available for use with SQL Server 2008:

  • Shared Memory—Enabled by default on all editions of SQL Server 2008, the Shared Memory protocol ...

Get SQL Server 2008: Administration in Action now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.