Thank you for your feedback.

Was this useful?

How To Determine If You Are Using A Static or Dynamic Port?

Article ID
ias-6218
Article Name
How To Determine If You Are Using A Static or Dynamic Port?
Created Date
30th April 2008
Product
Problem
I need to configure Windows Firewall to allow SQL Server to listen to TCPIP traffic but I am unsure if I am using a Dynamic or Static Port.
Resolution
Following the steps below will help to determine whether you are using a static or dynamic port. There are two methods to determine if you are using static or dynamic ports. Method 1
  • Click Start
  • Click Programs
  • Click Microsoft SQL Server
  • Click Configuration Tools
  • Click SQL Server Configuration Manager
  • Double Click SQL Server Network Configuration
  • Click Protocols for X NOTE: X refers to the installed instance name
  • Double Click TCPIP
  • Click IP Addresses
  • If there is a 0 in any of the rows labelled TCP Dynamic Ports> then you are using Dynamic ports.
  • Scroll down to the bottom to the section labelled TCPALL
  • The dynamic TCP Port is listed next to TCP Dynamic Ports
  • If you are using a static port the port number will be listed in each section next to TCP Port Method 2
  • Click Start
  • Click Run
  • In the Run box type Regedit
  • Click OK
  • Locate the HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\SuperSocketNetLib
  • Click TCP
  • The key TcpPort will be listed. The number listed will be the port number you will need to exclude within your firewall.
  • Quit Registry Editor. IMPORTANT: Serious problems might occur if you modify the registry incorrectly by using Registry Editor or another method. These problems might require that you reinstall your operating system. IRIS cannot guarantee that these problems can be solved. Modify the registry at your own risk. Related Articles KB IAS-6183 : How Do I Create An Exception for SQL Server 2008 in Windows Firewall? KB IAS-6184 : How Do I Create An Exception for SQL Server Browser in Windows Firewall? KB IAS-6219 : How To Configure Windows Firewall For UDP Port 1434 KB IAS-6220 : How To Configure Windows Firewall For TCP Port 1433 KB IAS-6221 : How To Configure Windows Firewall For TCP Ports

    Share This Page

  • Thank you for your feedback.

    Was this useful?