Back in February 22nd 2017, I posted a blog about "Where is SQL Server Configuration Manager". And, if you ever want to manage your SQL Server ports, this is the application we need to accomplished that tasks. As every SQL Server Administrator every knows, the default port is 1433, which in most cases can be left alone. But, you could change the default port to something different. Try to give it different port number. But, what about use the Dynamic Port number?
This is very simple change by doing the following steps:
1. Open your SQL Server Configuration Manager.
2. Navigate to SQL Server Networks Configuration
3. Select "Protocols for #YourSQLServerInstanceName#"
4. Under "Protocol Name", TCP/IP should be "Enabled"
5. Then, right-click on TCP/IP, and select the "IP Addresses" tab
6. Scroll-down to the "IPAll" section.
2. Navigate to SQL Server Networks Configuration
3. Select "Protocols for #YourSQLServerInstanceName#"
4. Under "Protocol Name", TCP/IP should be "Enabled"
5. Then, right-click on TCP/IP, and select the "IP Addresses" tab
6. Scroll-down to the "IPAll" section.
7. Any changes here will require a SQL Server restart.
Here's where you change your default port and can assigned a dynamic port is needed.
To test the changes, open SQL Server Management Studio, and under your SQL Server connection prompt enter the following information: "ComputerName,Port#orDynamicPort#" or "Computer-IPAddress,Port#orDynamicPort#".
Please, make sure the test any changes to ports done in SQL Server. Also, make sure to involve you company network security team for proper implementation.