Managing the Network and SQL Native Client Configuration

SQL Server installations can be configured to allow local and remote connections. SQL Server can use several protocols, including Shared Memory, Named Pipes, TCP/IP, and Virtual Interface Architecture (VIA). These protocols all have separate server and client configurations.

As shown in Figure 3-6, network configuration is set separately for each server instance through SQL Server Network Configuration. The client configuration is set on a per-client basis through SQL Native Client Configuration.

Viewing network configuration settings for a SQL Server instance.

Figure 3-6. Viewing network configuration settings for a SQL Server instance.

When multiple client ...

Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with O’Reilly online learning.

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