Instance & Port

• Kevin-130791

  SSChasing Mays

  Points: 622

  More actions

  September 16, 2005 at 12:15 pm

  #110008

  I have a SQL Sever with two instance plus the default, the default is listening on 1433 but the two instance are  on Port 0.  Should the two instance have a port number assign to them Or should they also have 1433?

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  September 16, 2005 at 3:53 pm

  #590758

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_cs_9okz.asp

  Net-Library	Default instance network address	Named instance network address
  TCP/IP Sockets	TCP Port 1433	A TCP port is chosen dynamically the first time the MSSQL$instancename service is started.