Dear Niall,
Great admirer of yours, All my SCCM knowledge credit goes to you.
I want to understand, If I am going through the manual installation approach for my LAB(SCCM 1702, domain controller server 2016 and sql server 2016 sp1) do I need to Enable Named Pipes and TCP/IP in SQL server protocols the same way you taught us in the sql 2008 for configuration manager 2012, Also Do I need to change the Status from Disabled (default) to Enabled for both the Servers local ip and localhost values in SQl server.