The copy-pastes and explanations blog for SQL code, errors and daily cases! This blog is a 'list' of actions that always good to have available. The copy-paste concept here is short and clear explanations and descriptions (no long stories!) and - of course - the code to take (copy) and use (paste). The blog deals in the database (mostly) and software issues.
Labels
SQL Server: Connect using a different port
Connect using a different port using a comma between the server name/IP and the port:
servername,port
or
serverIP,port
netstat - network statistics
netstat is a command displays statistics on all network activities.
main options:
-a Displays all active ports
-n Numerical display of addresses and port numbers
-o Displays the process identifiers (PID)
| grep 11753 - displays information only for IP 11753 (or other filter)
netstat -a -n | grep 11753
Test Open Ports with Telnet
telnet <IP_ADDRESS> <PORT_NUMBER>
Example:
telnet 30.125.40.120 5000
* If telnet doesn't work, turn "Telnet Client" on via "Programs and Features"-->"Installed updates"-->"Turn Windows features on or off".