what is the difference between remote port and local port?
1 Answer. The local port is the port number on the local computer, in this case your Windows 2016 server. The remote port is the port number on the remote computer, in this case the client that is connecting to your SQL server.