I use the following connection string in SQL Server Management Studio. It failed to connect:
mycomputer.test.xxx.com:1234\myInstance1
But the following one is ok:
mycomputer.test.xxx.com\myInstance1
So how do I specify a port number in a connection string?