The default SQL Server is assigned a default port of TCP:1433 for TCP/IP communication.

TCP:1433 is a widely known SQL Server port and this port assignment should be changed.

Using a non-default port helps protect the database from attacks directed to the default port.

---

1 – Open SQL Server Configuration Manager and expand SQL Server Network Configuration in the console pane. Expand Protocols for your InstanceName, and double click the TCP/IP protocol.

2 – In the TCP/IP Properties dialog box, on the IP Addresses tab, several IP addresses appear in the format IP1, IP2, up to IPAll. Additional IP addresses appear for each IP Address on the computer. Change the TCP Port field from 1433 to another non-standard port and click OK.

3 – In the console pane, click SQL Server Services.

4 – In the details pane, restart the SQL Server service to apply the changes.

---