I have installed Sql onto a new server and incorrectly plugged in the DHCP served NIC instead of the statically assigned NIC. If I change the NIC's, will it affect connectivity to it? Or will DNS just associate the NIC with the server. We are not using any TCP\IP aliases.