well, The default TCP/IP socket assigned for SQL Server is "1433 ".
SQL Server is a Winsock application that communicates over TCP/IP using the sockets network library. The SQL Server listens for incoming connections on a particular port; the default port for SQL Server is 1433. The port doesn't need to be 1433, but 1433 is the official Internet Assigned Number Authority (IANA) socket number for SQL Server.
A client application communicates to SQL Server using the client-side network library Dbmssocn.dll (or Dbnetlib.dll for SQL Server 2000) and any client using Microsoft Data Access Components (MDAC) 2.6.
When the client establishes a TCP/IP connection, a three-way handshake is done. The client opens a source port and sends traffic to a destination port, which by default is 1433. The client source port in use is random, but is greater than 1024. By default, when an application requests a socket from the system for an outbound call, a port between the values of 1024 and 5000 is supplied. For more information, see "Microsoft Windows 2000 TCP/IP Implementation Details" at the following Microsoft Web site:
http://technet.micros oft.c om/en-us/library/bb726981.aspx (http://technet.microsoft.com/ en-us /library/bb726981.aspx)
The server (in this case, SQL Server) then communicates to the client by sending traffic from 1433 back to the port that the client established.
Answered by Romi
at
11:52 AM on July 06, 2008
