Don’t know how to change the MSSQL port? We can help you.
Since port 1433 is the known standard for SQL Server, the default communication port used by SQL Server for TCP/IP mode connections is TCP 1433.
However, some organizations specify to change the SQL Server port number to enhance security.
As part of our Server Management Services, we assist our customers with several SQL queries.
In this article, let us see how to change the MSSQL port using SQL Server Configuration Manager.
Change MSSQL port
To assign a TCP/IP port number to the SQL Server Database Engine our Support Techs suggest the following:
a) In SQL Server Configuration Manager, in the console panel, expand SQL Server Network Configuration, expand Protocols for <instance name> and then double-click TCP/IP.
For example, MSSQLSERVER2016
b) In the TCP/IP Properties dialog box, on the IP Addresses tab, several IP addresses appear in the format IP1, IP2, up to IPAll.
One of these is for the IP address of the loopback adapter, 127.0.0.1. Additional IP addresses appear for each IP Address on the computer.
Right-click each address, and click Properties to identify the IP address that we want to configure.
c) If the TCP Dynamic Ports dialog box contains 0, indicating the Database Engine is listening on dynamic ports, delete the 0.
d) In the IPn Properties area box, in the TCP Port box, we type the port number we want this IP address to listen on, and then click OK.
If the Listen All setting on the Protocol tab is set to “Yes”, then it will only use TCP Port and TCP Dynamic Port values under the IPAll section and ignore individual IPn sections entirety.
If the Listen All setting is set to “No”, then it will ignore the TCP Port and TCP Dynamic Port settings under the IPAll section and use the TCP Port, TCP Dynamic Port, and Enabled settings on the individual IPn sections.
Each IPn section has an Enabled setting with a default value of “No” which causes SQL Server to ignore this IP address even if it has a port defined.
e) In the console panel, click SQL Server Services.
f) In the details panel, right-click SQL Server (<instance name>) and then click Restart, to stop and restart SQL Server.
Make sure the port is open in the Windows firewall.
In order to open a port, follow the steps given below:
- From the Start menu >> Control Panel >> System and Security >> Windows Firewall.
- Then click Advanced Settings >> Inbound Rules >> New Rule in the Actions window >> Rule Type of Port >> Next.
- On the Protocol and Ports page click TCP.
- Select Specific Local Ports and type the port number.
- Click Next.
- On the Action page, click Allow the connection.
- Click Next.
- On the Profile page, click the appropriate options for our environment.
- Click Next.
- On the Name page, enter a name.
- Click Finish.
- Restart the computer.
How to connect to a specific port
Once we configure SQL Server to listen on a specific port, there are three ways to connect to a specific port with a client application:
- Run the SQL Server Browser service on the server to connect to the Database Engine instance by name.
- Create an alias on the client, specifying the port number.
- Program the client to connect using a custom connection string.
[Couldn’t change MSSQL port? We’d be happy to assist you.]
In short, in this article, our Support Techs guides you on how to change the MSSQL port using SQL Server Configuration Manager.