Connection problems from a dual-NIC client

  • 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?

  • *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.

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


    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]

  • Thanks, that solved the problem.

  • Viewing 3 posts - 1 through 2 (of 2 total)

    You must be logged in to reply to this topic. Login to reply