Home Forums SQL Server 2005 Business Intelligence Could Active Directory Be Causing a connection manager to point to wrong server RE: Could Active Directory Be Causing a connection manager to point to wrong server

  • Yes, as with anything networking it needs an IP address not a hostname, so your DNS servers handle the hostname to IP address lookup for you.

    If your laptop is using DNS server 10.0.1.1 and your servers are using 192.168.1.1 and they both have an entry for MyServer, your DNS server could say well MyServer is on IP 10.45.6.7, while the servers DNS server may say that MyServer is on 192.168.34.6. So you will go to two different servers depending where your running the package from.

    So you will need to double check if both your laptop and your servers are sharing the same DNS servers, if they are, then there is something else going on like hostfile entires which will bypass your DNS servers, or even something like DNS caching where either one of you have the wrong IP stored in your DNS cache, or something more sinister is happening.