TCP/IP Properties (Protocols Tab)

SQL Server Configuration Manager

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

Reference

Creating a Valid Connection String Using TCP/IP

Concepts

Choosing a Network Protocol

Other Resources

How to: Enable or Disable a Server Network Protocol (SQL Server PowerShell)