Tips and Tricks

Connect to a different port with SQL Server Management Studio

Microsoft SQL Server Management Studio (SSMS) will default connect to port 1421 and there’s not obvious way to changing the port number. However it is possible by using a comma in the server name.

So in the example:,1521
First the server name, then a comma, and then the port number.