SCCM prerequisite check fail

Question

While installing SCCM 2403 with SQL Server 2019, the prerequisite check fails at the SQL Server TCP Port step. The error message states, "Configuration Manager primary site and central administration site require SQL Server TCP is enabled and set to Static port."

What steps can be taken to resolve this issue?

Answer 1

Hi, @golden alick

Thank you for posting in Microsoft Q&A forum.

Here are the steps you can take:

1. Open SQL Server Configuration Manager: This tool allows you to manage SQL Server services and network configurations.
2. Navigate to SQL Server Network Configuration: Expand the "SQL Server Network Configuration" section and select "Protocols for [Your Instance Name]".
3. Enable TCP/IP: Make sure that the TCP/IP protocol is enabled. If it is disabled, right-click on it and select "Enable". Configure TCP/IP Properties: Right-click on TCP/IP and select "Properties". Go to the "IP Addresses" tab. Under the "IPAll" section, set the "TCP Port" to a static port number (e.g., 1433). Ensure that the "Dynamic Ports" field is empty.
4. Restart SQL Server Services: After making these changes, restart the SQL Server services for the changes to take effect. You can do this from the SQL Server Configuration Manager.
5. Check Firewall Settings: Ensure that your firewall settings allow traffic on the static port you configured.

---

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".