none
Failover clustering outbound over host IP addresses RRS feed

  • Question

  • So we have setup a set of 2 node clusters with multiple SQL instances running in an active/passive configuration.

    Everything works fine for inbound communication as the SQL instances listen on the respective IP addresses, but! for outbound say to linked SQL where an external entity requires we have 1:1 NATs established they are failing regularly as the outbound traffic is using the physical host IP.

    After many hours of googling I have not found a solution to this and wonder why establishing /32 (1:1) static routes would not work to force the communication to traverse a specific interface on the cluster?

    eg: ROUTE ADD 12.12.12.12 MASK 255.255.255.255 172.1.1.1 METRIC 1 IF 3

    Thoughts?



    • Edited by BillJScott Monday, October 14, 2019 9:29 PM
    Monday, October 14, 2019 9:27 PM

All replies

  • More of a question for network team/Network guy than this SQl Server forum

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Tuesday, October 15, 2019 7:02 AM
    Moderator
  • Hi BillJScott,

    From your description, ip is a SQL server resource related to windows network. Your issue is  related to windows network . I suggest you open a thread in Windows network forums, People there will help you more effectively. 
    Hope this could help you.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, October 16, 2019 9:02 AM
  • Hi BillJScott,

    Did you resolve your issue? If you have resolved your issue, please mark the useful reply as answer. This can be beneficial to other community members reading the thread.
    In addition, if you have another questions, please feel free to ask.
    Thanks for your contribution.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, October 21, 2019 7:54 AM