Background I have two environments, TEST and STAGE. I use Microsoft Distributed Transaction Coordinator (MS DTC) with two linked 2008 SQL servers. A SQL job runs every couple of minutes and everything works fine on TEST. The SQL job does not run on STAGE. The only difference I have been able to pinpoint is that ping resolves to an IPv6 address on STAGE, but an IPV4 address on TEST. I suspect that MS DTC does not support IPv6.
Question I have three computers: testServer, stageServer, and productionServer. If I ping productionServer from testServer I get a reply from 192.168.1.2. If I ping productionServer from stageServer I get a reply from a long IPv6 address. Both testServer and stageServer have IPv6 and IPv4 enabled. Both testServer and stageServer use the same DNS servers, listed in the same order in the DNS tab. Why are the ping resolutions of IP's different?
TEST nslookup:
C:\Computer\me>nslookup
Default Server: dnsServer.domain.net
Address: 192.168.1.47
> productionServer
Server: dnsServer.domain.net
Address: 192.168.1.47
Name: productionServer.domain.net
Address: 192.168.1.2
>
STAGE nslookup:
C:\Computer\me>nslookup
Default Server: dnsServer.domain.net
Address: 192.168.1.47
> productionServer
Server: dnsServer.domain.net
Address: 192.168.1.47
** dnsServer.domain.net can't find productionServer: Server failed
>