Commerce Server - Cannot connect to named instance

Have seen this several times during install or CSConfig, have found that the best solution is to give the exact port number of the SQL instance and to make sure that you are communicating over TCP.