|
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)?
(comments are locked)
|
|
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.
(comments are locked)
|
|
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.
(comments are locked)
|
|
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.
(comments are locked)
|
