| title | Client Protocols - TCP IP Properties (Protocol Tab) | ||
|---|---|---|---|
| description | Learn how to specify TCP/IP options in Microsoft SQL Server Configuration Manager, such as the keep alive parameter and the default port number. | ||
| author | rwestMSFT | ||
| ms.author | randolphwest | ||
| ms.date | 03/14/2017 | ||
| ms.service | sql | ||
| ms.subservice | tools-other | ||
| ms.topic | conceptual | ||
| ms.collection |
|
||
| helpviewer_keywords |
|
||
| monikerRange | >=sql-server-2016 |
[!INCLUDE SQL Server Windows Only] In [!INCLUDEmsCoName] [!INCLUDEssNoVersion] Configuration Manager, use the Protocol tab on the TCP/IP Properties dialog box to view or specify the following options. To connect to a different port, type the port number in the Default Port box. For more information about connection strings, see Creating a Valid Connection String Using TCP IP.
Default Port
Specifies the port that the TCP/IP Net-library will use to attempt to connect to the target instance of [!INCLUDEssNoVersion]. The default value port is 1433.
When connecting to a default instance of [!INCLUDEssDE], the client uses this value. If a default instance has been configured to listen on a different port, change this value to that port number.
When connecting to a named instance of [!INCLUDEssDE], the client will attempt to obtain the port number from the [!INCLUDEssNoVersion] Browser Service running on the server computer. If the [!INCLUDEssNoVersion] Browser Service is not running, the port number must be provided through this setting, or as part of the connection string.
Enabled
Possible values are Yes and No.
Keep Alive
This parameter (in milliseconds) controls how often TCP attempts to verify that an idle connection is still intact by sending a KEEPALIVE packet. The default is 30000 milliseconds.
Keep Alive Interval
This parameter (in milliseconds) determines the interval separating KEEPALIVE retransmissions until a response is received. The default is 1000 milliseconds.
Choosing a Network Protocol
New Alias (Alias Tab)
<Alias> Properties (Alias Tab)