COMPUTER NETWORKING

Detailed explanation-1: -If enabled, the default instance of the SQL Server Database Engine listens on TCP port 1433. Named instances of the Database Engine and SQL Server Compact are configured for dynamic ports. This means they select an available port when the SQL Server service is started.

Detailed explanation-2: -TCP port 1433 is the default port for SQL Server. This SQL port is also the official Internet Assigned Number Authority (IANA) socket number for SQL Server.

Detailed explanation-3: -By default, SQL Server uses static TCP port number 1433 for the MSSQLSERVER instance. 1434 is used for UDP connections.

Detailed explanation-4: -In previous versions of MS-SQL server, port 1433 was enabled (open) by default, but as a hardening procedure implemented to improve security of the MS-SQL server, port 1433 is disabled in current versions of MS-SQL Server.

Detailed explanation-5: -Connect to your SQL server. Open the Windows firewall. Click on Inbound Rules. Select New Rule. Select the Port type of the rule. Specify the ports 1433 and 1434 to which this rule applies inside the Specific local ports area. In this step, leave the default selection: Allow the connection. More items