4 out of 7 rated this helpful - Rate this topic

Default SQL Server Network Configuration

SQL Server 2005

Updated: 5 December 2005

To enhance security, SQL Server 2005 disables network connectivity for some new installations. Network connectivity using TCP/IP is not disabled if you are using Enterprise, Standard, or Workgroup Edition or if a previous installation of SQL Server is present. For all installations, shared memory protocol is enabled to allow local connections to the server. The SQL Server Browser service might be stopped, depending on installation conditions and installation options.

Services and protocols can be started or enabled using the SQL Server Surface Area Configuration tool. Use the SQL Server 2005 Network Configuration node of SQL Server Configuration Manager to configure the network protocols after installation. Use the SQL Server 2005 Services node of SQL Server Configuration Manager to configure the SQL Server Browser service to start automatically.

Default Configuration

The following table describes the configuration after installation.

Edition	New install vs. previous installation is present	Shared memory	TCP/IP	Named pipes	VIA
Enterprise	New install	Enabled	Enabled	Enabled for local connections, disabled for network connections	Disabled
Standard	New install	Enabled	Enabled	Enabled for local connections, disabled for network connections	Disabled
Workgroup	New install	Enabled	Enabled	Enabled for local connections, disabled for network connections	Disabled
Developer	New install	Enabled	Disabled	Enabled for local connections, disabled for network connections	Disabled
Evaluation	New install	Enabled	Disabled	Enabled for local connections, disabled for network connections	Disabled
SQL Server Express	New install	Enabled	Disabled	Enabled for local connections, disabled for network connections	Disabled
All editions	Previous installation is present but not being upgraded	Same as new install	Same as new install	Same as new install	Same as new install
All editions	Upgrade	Enabled	Settings from the previous install preserved	Settings from the previous install preserved	Disabled

Note:
If the instance is running on a SQL Server 2005 failover cluster, it will listen on those ports on each IP address selected for SQL Server during SQL Server setup. To enable the network protocols, use either the SQL Server Surface Area Configuration tool or SQL Server Configuration Manager.

Note:
When installing SQL Server 2005 with command-prompt arguments, you can specify the protocols to enable by using the DISABLENETWORKPROTOCOLS parameter. For more information, see How to: Install SQL Server 2005 from the Command Prompt.

SQL Server Browser Settings

The SQL Server Browser service can be configured to start automatically during setup. The default is to start automatically under the following conditions:

When upgrading an installation.
When installing side-by-side with an instance of SQL Server 2000.
When installing on a cluster.
When installing a named instance of SQL Server Enterprise, Standard, or Workgroup Edition.
When installing a named instance of Analysis Services.

Release	History
5 December 2005	Changed content: Revised the list describing when the SQL Server Browser service is automatic started.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Default SQL Server Network Configuration

Concepts

Other Resources

Help and Information

Community Additions