How to listen SqlServer on multiple ports?

We can connect SQL Server on multiple ports. How can we do this step-by-step? 1- Open SQL Server Configuration Manager. 2- Click to expand SQL Server Network Configuration 3- Select your instance 4- On the right side, right click on TCP/IP then select properties.

5- In the tcp/ip window, select ip addresses tab 6- At the bottom of the window there is a IPAll part

7- In the TCP Port field, enter each port number separated by commas. Then click OK. 8- A pop up message will be appear. Click ok.

You must restart Sql Server Service. Stop and start Sql Server Service or restart. After the restarting, SQL Server will be listening on all the port numbers you specified. 9-If you would like to verify changes you can look at the Sql Server Logs. If it is successful you should see below messages in Sql Server Logs: Server is listening on [ ‘any’ <ipv4> 5555]. Server is listening on [ ‘any’ <ipv6> 5555]. Server is listening on [ ‘any’ <ipv4> 6666]. Server is listening on [ ‘any’ <ipv6> 6666]. Server is listening on [ ‘any’ <ipv4> 7777]. Server is listening on [ ‘any’ <ipv6> 7777]. 10-The other way to control connection is creating a UDL file. Create a udl file. Check the connection by entering the IP number and port.