Connect to SQL Server on Non Standard Port

by Pete Freitag

Need to connect to a SQL Server over TCP/IP on a non standard port (not 1433) with Microsoft SQL Server Management Studio 2005 Enterprise Manager?

Turns out the solution is also non-standard, use a comma in the host name (I had tried a colin, but that doesn't work...)

sqlserver.example.com,61433

Where 61443 would be the non standard port number.