Yes you are able to tell a sql server instance which IP address and ultimately which NIC to listen on. Check books online for more info
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉