SQL Server 2008 listening port settings in IP1, IP2, ....IPn, IPAll

• timf1234

  SSC Enthusiast

  Points: 109

  More actions

  September 10, 2010 at 10:08 pm

  #229217

  How can one tell which of the IP1, IP2, .....IPn, in sql server configuration manager is for the sql server?

  I want to assign a specific port number to the sql server.

  I am aware of the fact that I also need to open that pors in the windows firewall.

  I will type up the ip address, port number in the SSMS connection user interface to connect to the server from a remote location.

• Andy Hogg

  SSCarpal Tunnel

  Points: 4585

  More actions

  September 13, 2010 at 10:55 am

  #1220193

  Hi Tim,

  One way might be to look in the SQL Server log for the entry which is automatically made after the instance is started.

  You will see something along the lines of Server is listening on [10.43.56.5 <ip4> 2020]

  This gives you the address and the port that SQL Server is currently using.

  As you mentioned, you can easily change this within the configuration manager.