THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Kevin Kline

Available Ports On A SQL Server

Ever have a situation where you’d like to know what TCP/IP ports are open on your server?  Maybe you want to map database mirroring endpoints to specific ports or perhaps you need to replicate data through a specific port in a firewall out into the Internet?

 

In a situation like this, you’re best served by using an unassigned port number from the IANA registration database found at http://www.iana.org/assignments/port-numbers.  That way, you can be certain that you don’t choose a port that is in conflict with another application that is installed or will be installed some time in the future.  You could also take a short cut of using the dynamic or private ports in the range of 49125 to 65535.

 

Enjoy,

 

-Kev

Published Wednesday, October 31, 2007 1:42 PM by KKline
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

No Comments

Leave a Comment

(required) 
(required) 
Submit

About KKline

Kevin Kline is a well-known database industry expert, author, and speaker. Kevin is a long-time Microsoft MVP and was one of the founders of PASS, www.sqlpass.org.

This Blog

Syndication

Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement