changing TCP port

• MickyD

  SSCarpal Tunnel

  Points: 4601

  More actions

  February 10, 2010 at 8:56 am

  #229819

  Hello all.

  Bit stuck here.

  have number of named instances on SQL 2005 Sp3.

  One of the named instances needs to run on 1433.

  tried to change port numbers thru SQL Server Config Manager which has been done ok.

  However...

  Changed default instance to 5xxx

  named instance to 1433

  but the default instance seems to retain the connection associated with 1433.

  for example if I run a port script on my default instance set to port 5xxx I would expect to see 5xxx returned as result.

  However I don't , get named instance running on 1433 returned.

  Any advice on how to approach this ?

  is it something to do with dymanic port allocation?

  many thanks for all advice.

• SQLRocker

  SSCrazy

  Points: 2217

  More actions

  February 10, 2010 at 9:09 am

  #1116924

  I always keep Static Ports only, unless required by app team, try this:

  SSCM-N/W Configuration-TCP/IP (Enabled)-

  Protocol tab - Listen All - Yes

  IP Addresses tab - IPAll- Remove anything from TCP Dynamic Ports, Add Port # on TCP Port. Restart SQL Service. Repeat for the other instance.