Issue Reported:

While installing SCCM 1606 Getting error : Configuration Manager primary site and central administration site require SQL Server Tcp is enabled and set to Static port.

Below error in ConfigMgrPrereq.log :-

Solution:

Open SQL Server configuration Manager  and Click on Sql Server Network Configuration -  Double Click on TCP/IP

On properties tab drag down till IP all and Remove TCP Dynamic Ports all entry as below screen shoot.

After performing above  SCCM 1606 Prerequisite check get pass successfully.

Happy Learning!!!!

Thanks&regards,
Haresh Hirani
Email: [email protected], [email protected]
Facebook https://www.facebook.com/Hiraniconfigmgr-120189361980772/
Follow us: https://www.linkedin.com/in/hiraniconfigmgr 
Twitter: https://twitter.com/hiraniconfigmgr