Can I change the default port 1433？

Question

I am running MECM with SQL Server 2016, can I change the default port number tcp 1433 to a custom one? Is there any impact for MECM？

Answer 1

Hi, @KlayTomper

Thank you for posting in Microsoft Q&A forum.

Yes, it's available, but it's not recommended if you only have one SQL Server instance on the Server.

We can use SQL Server Configuration Manager to configure the custom TCP port, remember to leave the TCP Dynamic Ports null.

Here is the guidance we may refer to:

https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-a-server-to-listen-on-a-specific-tcp-port?view=sql-server-ver16

And after the configuration, we have to do the following to make sure SCCM can use the custom port correctly:

1. Make sure the corresponding firewall entries are for the custom port
2. Change the SMS site server DSN in ODBC Connections to the custom port:

Administrative Tools -> Data Sources (ODBC) -> System DSN tab -> Configure SMS SQL -> Next -> Client Configuration -> Uncheck Dynamically determine port and specify custom port.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Add comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.