Managing the Network and SQL Native Client Configuration
In the section "Managing the Connections Configuration" earlier in this chapter, you learned that 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 VIA. These protocols all have separate server and client configurations.
The network configuration is set separately for each server instance through the SQL Server Network Configuration. The client configuration is set on a per client basis through the SQL Native Client Configuration.
Note
Any system on which you have installed ...
Get Microsoft® SQL Server™ 2005 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.
