| title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | ||
|---|---|---|---|---|---|---|---|---|---|---|
Default SQL Server Network Protocol Configuration |
View factors that affect whether network protocols are turned on or off during SQL Server installation. See how to configure protocols after installation. |
rwestMSFT |
randolphwest |
01/19/2019 |
sql |
configuration |
conceptual |
|
[!INCLUDE SQL Server] To enhance security, [!INCLUDEssNoVersion_md] disables network connectivity for some new installations. Network connectivity using TCP/IP is not disabled if you are using the Enterprise, Standard, Evaluation, or Workgroup edition, or if a previous installation of [!INCLUDEssNoVersion_md] is present. For all installations, shared memory protocol is enabled to allow local connections to the server. The [!INCLUDEssNoVersion_md] Browser service might be stopped, depending on installation conditions and installation options.
Use the [!INCLUDEssNoVersion_md] Network Configuration node of [!INCLUDEssNoVersion_md] Configuration Manager to configure the network protocols after installation. Use the [!INCLUDEssNoVersion_md] Services node of [!INCLUDEssNoVersion_md] Configuration Manager to configure the [!INCLUDEssNoVersion_md] Browser service to start automatically. For more information, see Enable or Disable a Server Network Protocol.
The following table describes the configuration after installation.
| Edition | New installation vs. previous installation is present | Shared memory | TCP/IP | Named pipes |
|---|---|---|---|---|
| Enterprise | New installation | Enabled | Enabled | Disabled for network connections. |
| Standard | New installation | Enabled | Enabled | Disabled for network connections. |
| Web | New installation | Enabled | Enabled | Disabled for network connections. |
| Developer | New installation | Enabled | Disabled | Disabled for network connections. |
| Evaluation | New installation | Enabled | Enabled | Disabled for network connections. |
| SQL Server Express | New installation | Enabled | Disabled | Disabled for network connections. |
| All editions | Previous installation is present but is not being upgraded. | Same as new installation | Same as new installation | Same as new installation |
| All editions | Upgrade | Enabled | Settings from the previous installation are preserved. | Settings from the previous installation are preserved. |
Note
If the instance is running on a [!INCLUDEssNoVersion_md] failover cluster, it listens on those ports on each IP address selected for [!INCLUDEssNoVersion_md] during [!INCLUDEssNoVersion_md] setup.
Note
When you are installing [!INCLUDEssNoVersion_md] with command-prompt arguments, you can specify the protocols to enable by using the TCPENABLED and NPENABLED parameters. For more information, see Install SQL Server from the Command Prompt.
See the following topics for samples of connection strings:
- Creating a Valid Connection String Using Shared Memory Protocol
- Creating a Valid Connection String Using TCP IP
[!INCLUDEssNoVersion_md] Browser Settings
The [!INCLUDEssNoVersion_md] 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 another instance of [!INCLUDEssNoVersion_md].
- When installing on a cluster.
- When installing a named instance of the Database Engine including all instances of [!INCLUDEssNoVersion_md] Express.
- When installing a named instance of Analysis Services.
Hardware and Software Requirements for Installing SQL Server 2016