O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Companion by Victor Isakov, Stacia Misner, Burzin Patel, Marcilina Garcia, Edward Whalen

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

Configuring Network Protocols

SQL Server 2005 by default disables certain network protocols to enhance the security of the server. Table 9-1 presents the default protocol status for each SQL Server 2005 edition.

Table 9-1. Default Network Protocol Configurations

SQL Server 2005 Edition

Shared Memory

TCP/IP

Named Pipes

VIA

Express

Enabled

Disabled

Enabled for local connections, disabled for remote connections

Disabled

Workgroup

Enabled

Enabled

Enabled for local connections, disabled for remote connections

Disabled

Standard

Enabled

Enabled

Enabled for local connections, disabled for remote connections

Disabled

Enterprise

Enabled

Enabled

Enabled for local connections, disabled for remote connections

Disabled

Developer

Enabled

Disabled

Enabled for local connections, disabled for ...

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