Port numbers range to select for SQL Sevrer instances

• passivebyz

  SSCommitted

  Points: 1908

  More actions

  June 2, 2010 at 9:43 am

  #141264

  Hi,

  We have SQL Server 2005 named instances and so far we are using dynamic ports. But I came to know that we should use static ports to more secure the system. So I want to implement that and want to know what is the range of port numbers we can open and assign for an instance?

  Is there any range exists and we need to select the port number from that range only? or

  Can we give any port number? how many digits that port number can have?

  Is there any limitation that we should use only 4 numbers in Port number or 3 numbers like that?

  Where can I find this info in MSDN?

  Thank you

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736297

  More actions

  June 2, 2010 at 10:04 am

  #1175400

  Here you go: http://www.iana.org/assignments/port-numbers

  Typically I use something above 50,000 to avoid conflicts.