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 ...
Get Microsoft® SQL Server® 2008 Administrator's Pocket Consultant now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
