Export (0) Print
Expand All

Default SQL Server Network Configuration

To enhance security, SQL Server disables network connectivity for some new installations. Network connectivity using TCP/IP is not disabled if you are using the 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.

Use the SQL Server Network Configuration node of SQL Server Configuration Manager to configure the network protocols after installation. Use the SQL Server Services node of SQL Server Configuration Manager to configure the SQL Server Browser service to start automatically.

The following table describes the configuration after installation.

Edition

New installation vs. previous installation is present

Shared memory

TCP/IP

Named pipes

VIA

Datacenter

New installation

Enabled

Enabled

Disabled for network connections1

Disabled

Enterprise

New installation

Enabled

Enabled

Disabled for network connections1

Disabled

Standard

New installation

Enabled

Enabled

Disabled for network connections1

Disabled

Workgroup

New installation

Enabled

Enabled

Disabled for network connections.1

Disabled

Developer

New installation

Enabled

Disabled

Disabled for network connections1

Disabled

Evaluation

New installation

Enabled

Disabled

Disabled for network connections1

Disabled

SQL Server Express

New installation

Enabled

Disabled

Disabled for network connections1

Disabled

All editions

Previous installation is present but is not being upgraded.

Same as new installation

Same as new installation

Same as new installation

Same as new install

All editions

Upgrade

Enabled

Settings from the previous installation are preserved.

Settings from the previous installation are preserved.

Disabled

When shared memory (a local named pipe) is enabled, local connections can connect to the instance by using the named pipes protocol. To connect to the default instance, use osql -E –S np:. as the connection string. To connect to a named instance, use osql -E -S \\.\pipe\MSSQL$<instance_name>\sql\query as the connection string.

NoteNote

If the instance is running on a SQL Server 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 SQL Server Configuration Manager.

NoteNote

When you are installing SQL Server with command-prompt arguments, you can specify the protocols to enable by using the TCPENABLED and NPENABLED parameters. For more information, see How to: Install SQL Server 2008 R2 from the Command Prompt.

NoteNote

The VIA protocol is deprecated. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

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 2008.

  • When installing on a cluster.

  • When installing a named instance of the Database Engine including all instances of SQL Server Express.

  • When installing a named instance of Analysis Services.

Community Additions

ADD
Show:
© 2014 Microsoft