TCP/IP Properties (Protocols Tab)

SQL Server Configuration Manager

previous page next page

Updated: 5 December 2005

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 2005 does not implement changes to this property.

Change History

Release History

SQL Server 2005Service Pack 1
Changed content:
  • Provided definition for Keep Alive.

See Also

previous page start next page