Was stuck today trying to get Windows 7 SQL Server Management Studio 2005 to talk to one of the database servers running on a port different from 1443. For those who are unable to connect to SQL server using the SQL server management studio 2005 you can specify the port you wish to connect to by using the format :
IP,port\instancename
Example:
192.168.1.20,4023\bloggybloggy
If above fails try either of the following formats :
192.168.1.20,4023 \bloggybloggy
192.168.1.20, 4023 \bloggybloggy
Only difference is there is extra space.
Good luck connecting to your sql server. And those who are trying to connect to server that uses domain based windows authentication simply create a shortcut as below to the SQLwb file and it will ask you to login with your network id and connect to server as if you are connection via domain and using windows authentication.
C:\Windows\System32\runas.exe /user:DOMAINHERE\YOURIDHERE “C:\Program Files (x86)\Microsoft SQL Server\90\Tools\binn\VSShell\Common7\IDE\SqlWb.exe”
