TCP PORT

• shanila_minnu

  Hall of Fame

  Points: 3465

  More actions

  October 18, 2011 at 10:45 pm

  #245498

  I have a server in which only a single sql server instance is installed on it.That single instance is a named instance.

  I need to know when we install a single named instance on a server, which port it will defaultly select?(Normal case default instance will go for 1433 and named instance to dynamic).

  Kindly do reply...

• Shabba

  SSCertifiable

  Points: 5007

  More actions

  October 19, 2011 at 3:17 am

  #1396511

  It will default to the dynamic TCP port configured within SQL Server Configuration Manager. You will probably want to change this from a dynamic port to a static port.

  It will not use TCP 1433 unless you specifically change it!

  Regards,

  Mark

• R_S

  Ten Centuries

  Points: 1160

  More actions

  October 19, 2011 at 3:11 pm

  #1396987

  SQL Server 2005 uses the dynamic port when a named instance is installed. You can change your port to the static port from Configuration Manager.