SQL Job authentication on dual-NIC VM
Posted on 2014-02-10
I have a Server 2012 R2 VM running SQL 2012. The VM has two NICs, one is NAT to a local domain controller, the other is bridged so I can access the VM from outside the NAT network.
With only the NAT NIC attached, my SQL jobs run fine, with job owners authenticating to the local domain controller.
With both the NAT and bridged NICs attached, my SQL jobs fail with error code 0x54b (The specified domain either does not exist or could not be contacted) SQLSTATE 42000 Error 15404. It appears as though SQL favors the Bridged adapter for authentication when both bridged and NAT adapters are present.
Does anyone know of a way to tell SQL to always authenticate on the NAT adapter, even if the bridged adapter is present?