How to configure the SCW for SQL access using a named instance and port

Version 1

    Details

    When installing HEATSM in some environments the SQL server may have a named instance or a custom port (not 1433).  How do we configure this in the SCW?

    SCW is not accepting the connection string with various combinations that have been tried so far and returns a connection error:

     


    Resolution

    The format for a named SQL instance with a custom port number should be:
    {machinename}\{instance},{portnumber}

    i.e. "SQL2012\NamedIns,1234" would point to
    -server SQL2012
    -instance NamedIns
    -port 1234