My sqlServer use to have only 1 NIC with the following address: 192.168.1.11

I have multiple client connecting through that address.

Now I have a new set of clients that need to be on a different subnet, 192.168.110.x and we added a second NIC on the server with the address 192.168.110.11.

All subnet masks are 255.255.255.0


The new clients (on the 192.168.110 subnet) cannot connect to hte server if I specify 192.168.110.11 as the server's address. But they connect using 192.168.1.11 address.


How do I instruct SQLServer to listen on both NIC for connections ?

Thanks.