Connection problems from a dual-NIC client

• Scott Coleman

  One Orange Chip

  Points: 27452

  More actions

  October 11, 2016 at 1:05 pm

  #75751

  We have a dual-NIC computer that straddles the DMZ; one NIC is on a DMZ subnet and the other is on an internal subnet. (I didn't set it up, don't bother pointing out what a bad idea this is.)

  A program on this computer needs to connect to an internal SQL Server. When it uses the correct NIC it succeeds, when it tries using the DMZ NIC it is blocked by firewall rules. We've tried connecting by IP address instead of host name to get it to use the correct NIC, but it still fails half the time.

  Any suggestions on how to force the choice of NIC for a SQL Server OLDEB connection?

• mister.magoo

  SSC-Forever

  Points: 47068

  More actions

  October 11, 2016 at 2:57 pm

  #1905996

  *I cannot ignore it - please don't *

  Now, check your routing table on the client - it should be re-configured to always send traffic via the internal nic for your sql server.

  https://technet.microsoft.com/en-gb/library/bb490991.aspx

  You will want the "if interface" option...

  MM
  

  ---

  
  select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

• Forum Etiquette: How to post Reporting Services problems
[/url]
• Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]
• How to Post Performance Problems - by Gail Shaw
[/url]