The architecture of our server environment dictates that we connect to SQL instances via dns ( We discovered when using SQL instances we needed to add the port number of the instance in order to make this work (,1955). We use several instances per machine and did some research to find a range of ports that weren’t used by Windows and forced the instances to use these ports. Hopefully someone will find this helpful.