While installing the SCCM using Baseline Media, you might see the error SQL Server Tcp port status showing as Failed. I am going to discuss on this, the reason behind this error and how to resolve it.

Prerequisite Check Error – SQL Server

When installing Configuration Manager using baseline media, it has to go through prerequisite check where it verifies all the configuration is in place to start and initiate the installation process.

You might see the error during Microsoft Endpoint Configuration Manager Setup Wizard > Prerequisite Check showing

SQL Server Tcp port: Status “Failed

SQL Server Tcp Port Failed

 The reason for this error is: SQL Server uses TCP port 1433 as the default port for default instance & for named instance dynamic ports are used. Even though I used named instance which should support dynamic ports, it still doesn’t work with SCCM SQL server configuration.

Hence, what we need to do, is to remove TCP Dynamic Ports and set TCP Port to 1433

SQL Server Configuration Manager Protocols

Changes Required for SQL Server TCP Port

Launch Sql Server Configuration Manager, navigate to Protocols for <Named Instance>. On right Pane to go to the properties of TCP/IP.

Once opened, click on IP Addresses tab. Scroll down until you see section IPALL. You will see following:

TCP Dynamic Ports set to some Dynamic ports range (49152 to 65535), in my case it was 49960.
TCP Port is blank.

TCP/IP Properties TCP Port

Make following changes:

TCP Dynamic Ports : remove the value (make it blank)
TCP Port :
Set it to 1433

TCP/IP Properties TCP Dynamic Ports

Click OK, warning will be displayed, Click OK one more time.

SQLSererTCPPortFailed 05

Restart the Service

We need to restart SQL Server (Named Instance) service to apply the new configuration.

SQL Server Service

Once done, we can return to Configuration Manager Prerequisite Check page wizard. Click on Run Check and this time you will get success for that specific error which was failing previously.

Reference Link

Configure a Server to Listen on a Specific TCP Port – SQL Server | Microsoft Docs