SQL instance connection error – ‘A network-related or instance-specific error occurred’

I was stumped with this error for hours last night while building out some on-premises SharePoint Farms. I was trying to connect to a specific named instance as opposed to the default instance.  I thought I would blog about the fix because it’s something I’ve never come across before and it took some googling of…