Binding to addresses

• hernick

  Newbie

  Points: 7

  More actions

  November 7, 2001 at 12:47 am

  #101041

  How would one get SQL Server 7 SP3 running on Windows NT 4 SP6a to bind and listen to multiple IP addresses ? The server uses two IP addresses, 192.168.1.11 and 213.110.x.x, and I'd like it to bind to both, so that I can access it by specifying either address in my programs.

  Right now, it only binds to the primary address, 213.110.x.x

  Thanks !

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  November 7, 2001 at 11:09 am

  #419786

  If you add the second address to the NIC in NT, then you need to reboot the box and SQL should listen on all NICs/addresses.

  I have multi=homed boxes and this works, though the reboot was necessary for SQL to begin listening on the port.

  Steve Jones

  steve@dkranch.net