THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | Join | Help
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) 
(optional)
(required) 
Submit

About KKline

Kevin Kline is Technical Strategy Manager for the SQL Server business unit at Quest Software. Kevin was the original architect and dev manager for many of Quest's SQL Server tools. Prior to Quest, Kevin worked as an enterprise DBA for a variety of large corporations and government agencies.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement