O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

Note

Any system on which you have installed ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required