SQL Server supports > 1 IP address (and has since 2000), so clearly it was designed to work on multi-homed servers. Where his concern may stem from is using up multiple ports in your hubs, routers, etc.

The server is multihomed having a interface card on the LAN and a interface card pointing to the backbone for internet access. Internet access works fine through ISA server. The problem comes with Multihoming an Ethernet-Connected End System Design and Configuring a Multihomed Ethernet-Connected End System using EVPN Multihoming with VLAN Trunking, Enabling Storm Control, Multihoming a Ethernet-Connected End System—Release History Dual-homed - Wikipedia Dual-homed is a general term for proxies, gateways, firewalls, or any server that provides secured applications or services directly to an untrusted network. Dual-homed hosts can be seen as a special case of bastion hosts and multi-homed hosts. They fall into the category of application-based firewalls. Multi-homed server, lock ICA and RDP to a specific NIC Apr 21, 2016

Multihoming: Things To Keep In Mind When A Computer Has

multihomed (adj.) Typically used to describe a host connected to two or more networks or having two or more network addresses. For example, a network server may be connected to a serial line and a LAN … Linux How to setup multi homing network - nixCraft Nov 08, 2006

Jun 19, 2013

Aug 14, 2017 Configuring multihomed hosting - IBM