THE SQL Server Blog Spot on the Web

Welcome to - 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  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.





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


No Comments

Leave a Comment


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,

This Blog



Privacy Statement