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.
Figure 3-6. Viewing network configuration settings for a SQL Server instance.
When multiple client ...