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

configmgrprereq-log

Solution:

Open SQL Server configuration Manager –> 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.

tcp-ip

Happy Learning!!!!

Thanks & Regards,
Haresh Hiran

 

Advertisements