Client Protocols - TCP/IP Properties (Protocol Tab)

In Microsoft SQL Server 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.

Options

  • Default Port
    Specifies the port that the TCP/IP Net-library will use to attempt to connect to the target instance of SQL Server. The default value port is 1433.

    When connecting to a default instance of Database Engine, 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 Database Engine, the client will attempt to obtain the port number from the SQL Server Browser Service running on the server computer. If the SQL Server 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.