Static Port of Named Instance

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  November 3, 2015 at 11:57 pm

  #309376

  Hi Experts,

  I changed the Port of my named instance to use static port but still error log is giving two values ,why??

  spid15sServer is listening on [ 'any' <ipv6> 50152].

  spid15sServer is listening on [ 'any' <ipv4> 50152].

  ServerServer is listening on [ ::1 <ipv6> 57518].

  ServerServer is listening on [ 127.0.0.1 <ipv4> 57518].

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  November 4, 2015 at 1:50 am

  #1837539

  Can you post screenshots of your TCP/IP configuration

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  November 4, 2015 at 4:08 am

  #1837584

  Thanks Anthony. PFA

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  November 4, 2015 at 4:17 am

  #1837589

  Generally I put 0 in TCP Dynamic Ports for all of the IP segments except IPAll.

• VastSQL

  SSC-Dedicated

  Points: 36097

  More actions

  November 4, 2015 at 4:21 am

  #1837592

  Thanks Anthony.

  Went with this link

  http://blogs.msdn.com/b/arvindsh/archive/2012/09/08/how-to-assign-a-static-port-to-a-sql-server-named-instance-and-avoid-a-common-pitfall.aspx

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  November 4, 2015 at 4:26 am

  #1837594

  Ah, ok, I have never run into this issue in the past, but will keep it in mind should I encounter it.