TCP/IP Properties (Protocols Tab)
Applies to: 
SQL Server - Windows only
Use the TCP/IP Properties dialog box to configure the options for the TCP/IP protocol. Click TCP/IP in the left pane, to show individual IP address configurations in the details pane.
Microsoft SQL Server must be restarted before the changes take effect.
Options
Enabled
Possible values are Yes and No.
Keep Alive
Specify the interval (milliseconds) in which keep-alive packets are transmitted to verify that the computer at the remote end of a connection is still available.
Listen All
Specify whether SQL Server will listen on all the IP addresses that are bound to network cards on the computer. If set to No, configure each IP address separately using the properties dialog box for each IP address. If set to Yes, the settings of the IPAll properties box will apply to all IP addresses. Default value is Yes.
No Delay
SQL Server does not implement changes to this property.
See Also
Choosing a Network Protocol
Creating a Valid Connection String Using TCP IP
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for