Using port number to connect to a SQL Server

This is one of the common questions I experienced from many folks when they attempt to connect to a SQL instance using Port Number instead of Instance Name. Irrespective of version of SQL Server, you can run the SQL Server on a TCP/IP port and can use SQL Server’s IP and port number combination instead of using typical SQLServername\Instancename to connect to it.

For example, SQL instance running on Port number 1193 of 192.42.10.45 can be connected as 192.42.10.45, 1193