Share via


Default SQL Server Network Configuration

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.

See Also

Concepts

Default Client Connection Behavior

Other Resources

Hardware and Software Requirements for Installing SQL Server 2005
SQL Server Surface Area Configuration

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release History

5 December 2005

Changed content:
  • Revised the list describing when the SQL Server Browser service is automatic started.