The most effective method to Configure MS SQL Server to Listen on a given port
How would I arrange an occasion of MS SQL Server Database Engine to tune in on a particular fixed port? This guide will walk you through the way toward arranging your SQL Server Database Engine to tune in on a port that you pick utilizing SQL Server Configuration Manager. Let us begin:
Stage 1: Open Configuration Manager
Hit Windows Keyboard key and quest for SQL Server Configuration Manager as appeared in the screen capture beneath
Stage 2: Server Network Configuration
Once SQL Server Configuration Manager is open, click on the drop-down rundown of SQL Server Network Configuration and pick “Conventions for [name of your SQLServer]”. That will uncover three choices on the correct board as appeared on the picture beneath:
Stage 3: Unset Listen to All
Right-click on the TCP/IP and pick Properties which will pop another TCP/IP Properties window as shown below.
On the Window, there are two Tabs on the upper left corner, which is Protocol and IP Address. Contingent upon which IP and port you would wish your Database Engine to tune in on, the settings on the Protocol Tab will support you. As a matter of course, listening is set to All on the “Listen All” part. On the off chance that you would want explicit IPs and Port to be used, set this incentive to No as shown below.
Stage 4: Change MS SQL Service TCP Port
Snap-on IP Address Tab. In that few IP delivers areas give off an impression of being appeared as IP1, IP2, up to IPAll. One of these is for the IP address of the loopback connector, 127.0.0.1. In the event that you left “Tune in” to “All” in the Protocol Tab, at that point head over to the IPALL area and set the TCP Port to your ideal number and erase the 0 against TCP Dynamic Ports as shown below.
Stage 5: Configure Database Engine Port
In the event that you set “Listen All” part to No, head over to IP1, change “Enabled” to “Yes”, type in the IP Address eg 10.20.2.29 here, erase the 0 in TCP Dynamic Ports and key in the Port you would wish the Database Engine to Listen from. Check the screen capture beneath for progressively visual subtleties. After you are finished entering in the vital information, click Apply and OK.
Stage 6: Enable TCP/IP
After the above advances are done, right-click on TCP/IP and select Enable as shown below.
Stage 7: Restart MS SQL Service
Restart your MS SQL Instance. Hit the Windows button and search for Services.
Under Services, search for SQL Server (your_instance).
Right-click on it and pick Restart.
Your SQL Server is now listening on the Port you have specified. You only need to enable the port on Windows Firewall if it was not allowed yet.