Step 1: Open Control Panel → Windows Firewall → Advanced Settings.

Step 2: Click Inbound Rules → New Rule.

Step 3: Select Port, then choose TCP.

Step 4: Enter 1433 (default SQL Server port).

Step 5: Choose Allow the connection.

Step 6: Apply to Domain, Private, Public profiles as needed.

Step 7: Name the rule SQL Server Port 1433 and finish.

Save the following as OpenSQLPort.bat and run as Administrator:

@echo off
REM === Open SQL Server port on Windows Firewall ===
set PORT=1433
set RULE_NAME="SQL Server Port %PORT%"

netsh advfirewall firewall add rule name=%RULE_NAME% ^
    dir=in action=allow protocol=TCP localport=%PORT%

pause
    

• set PORT=1433 → Default SQL Server port (change if needed).
• netsh advfirewall firewall add rule → Creates inbound rule.
• protocol=TCP localport=%PORT% → Opens the port for SQL traffic.
• pause → Keeps window open for confirmation.