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)?
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.
What name resolution techniques are in place in your environment?
DNS?
WINS?
Broadcast?
Does an nslookup SQLServerName work?
How about a ping -a IPaddress?
If all else fails drop an entry in the Client's hosts file.
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.
