Running SQL Server 2000 on a LAN. When setting up ODBC system DSN, some client machines find the server name but others not, requiring the usage of the IP address. Is there a local configuration file that needs to be ammended, or is it a server issue (be it SQL or network)?
asked Mar 18 '10 at 12:22 PM in Default
The issue is the client machine that cannot see it via Name.
Try ipconfig /flushdns ipconfig /registerdns
from the command prompt on the client machines with the problems.
answered Mar 18 '10 at 12:25 PM
It is possible that you are blocking UDP 1434 as well from some machines. I believe that a lookup from client tools for all servers uses this port.
answered Mar 18 '10 at 02:21 PM
Steve Jones - Editor ♦♦
What name resolution techniques are in place in your environment?
Does an nslookup SQLServerName work?
If all else fails drop an entry in the Client's hosts file.
answered Mar 18 '10 at 12:38 PM