One of the first things to do for securing your SQL Server is to change its default TCP port. You can configure a static or dynamic port for SQL Server network configuration.
To view the default port, launch SQL Server Configuration Manager and click on SQL Server Network Configuration and Protocols for MSSQLSERVER. For the named instance, you will see option – Protocols for <NamedInstance>
As shown below, my SQL Instance is running on port 1433.
Specify a new port in the TCP Port section to change a static port. As shown below, I changed the default TCP port to 1201.
It requires SQL Service restart to take the change into effect. Click Ok and restart SQL Service.
Once done, verify the connection SQL Instance with the new port number.
As shown below, we connected successful to our SQL Server instance with non-default(static) port.
You can view the configured port in SQL Server error logs. Expand the SQL Server Logs folder and double-click on Current, and you can see entries in the logs as shown below.
Comments