Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abc
Starting Member
48 Posts |
 Posted - 2004-03-01 : 05:04:39
|
| My SQL server is using dynamic IP address, when clients connect to server they all have to use IP address, can not use server's name. How to let them connect to my server by server's name ?Thanks any helpThanks for your attention |
|
|
safigi
Starting Member
15 Posts |
Posted - 2004-03-01 : 07:27:17
|
| You should to use ipconfig /flushdns. But this is not the best solution for you. You can use dynamic ip addresses but you should to reserve the ip address for that server (and all of your servers) in the dhcp manager.Safi |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-03-01 : 13:06:06
|
| You should not be using dynamic IPs on a SQL Server.And yes they should be able to connect using the machine name regardless if it has dynamic IP or not. DNS should handle the name resolution.Tara |
|
|
|
abc
Starting Member
48 Posts |
Posted - 2004-03-02 : 05:21:49
|
| it's must be funny, when I ping for localhost my IP address differ from IP return when other PC ping to my server name. It's seem that DNS don't know my localhost IP, so admint say that he delete the old IP address (IP return when other PC ping to my server) on DNS server. And my server work fine now. |
|
|
|
|
|
|
can't connect by server name