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”
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
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.
Make following changes:
TCP Dynamic Ports : remove the value (make it blank)
TCP Port : Set it to 1433
Click OK, warning will be displayed, Click OK one more time.
Restart the Service
We need to restart SQL Server (Named Instance) service to apply the new configuration.
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.