I couldn’t believe the hassle it was trying to find how to specify a different port number when using SQL Server Management Studio. And of course it’s pretty easy too.
Below we have a typical connection dialog for Management Studio:
The Server name text box is where the server address (instance) goes. In this example I am using the IP address 192.168.38.1
To specify the port number use a comma and then the port number after it.
E.g. 192.168.38.1, 14333
That’s it, that is all you need to do. You would think something this important would be in the help screen when you press help.
2 comments
Comments feed for this article
Wednesday, September 23, 2009 at 16:04:26
anon
typically you use a colon.
192.168.38.1:1433
Wednesday, September 23, 2009 at 17:05:18
Brettski
You would think that, though colon has never worked for me in Management studio 2000 or 2003 (haven’t tried it 2008). That was the whole reason for this post, because it wasn’t an obvious port declaration.
Thank you for your comment!
Brett