This article explains how to configure SQL server to listen on a non-standard port number.
Problem
How to configure the SQL server to listen on a specific port?
See AlsoHow do I link two SQL servers so I can run queries between them?Can I change the default port 1433？ - Microsoft Q&AHow to connect to sql listener without specifying custom port number - Microsoft Q&ASQL SERVER - How to Listen on Multiple TCP Ports in SQL Server? - SQL Authority with Pinal Dave
Solution
Owing to security issues it is often not recommended to use the default port number 1433 for communicating with the SQL server. This article helps set up the SQL server to use a non-standard port number.
Run the SQL Server Configuration Manager.
Select the SQL Server Network Configuration.
Select from the list the instance you want to configure to listen to on a specific port.
To change the port assignment right-click on the TCP/IP protocol and select Properties.
Click on the IP Addresses tab.
Note: Both IP5 and IP6 are disabled and the TCP Dynamic Ports setting is set to “0”, which means that the database engine is listening on dynamic ports.
Specify the port number you want to use instead of 1433 by entering the preferred port number. Also, turn off the dynamical port number setting by removing the “0” mark in the TCP Dynamic Ports field.
In order to finish the adjustment, select SQL Server Services, click on SQL Server and restart it.
Last updated
