What is IPAll in TCP/IP properties protocol tab?

• san43

  Hall of Fame

  Points: 3196

  More actions

  January 10, 2012 at 10:04 am

  #262683

  What is IPAll in TCP/IP properties protocol tab?

  I have set static port for only one IPAddress available in the protocol tab and set enabled to NO for all others. One more I have set ListenAll to NO.

  Do I still need to specify the same port number in the IPAll section?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  January 10, 2012 at 11:03 am

  #1431308

  Would be redundant IMHO.

  Does it work with IPAll blanked? Then, leave it blank.

  -- Gianluca Sartori

• Perry Whittle

  SSC Guru

  Points: 234065

  More actions

  January 10, 2012 at 11:30 am

  #1431328

  san43 (1/10/2012)

  ---

  What is IPAll in TCP/IP properties protocol tab?

  it is the port that sql server would listen on for all IPs assigned to the server

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs" 😉