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 |
|
osullivj35
Starting Member
1 Post |
 Posted - 2005-06-16 : 11:19:15
|
| HiMy colleague has set up MSDE on his machine. I am only able to connect to his machine via IP and not servernameWhy is this? I want to use ACCESS as a fornt end and can't useing IP addressJerry |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2005-06-16 : 12:34:56
|
| Can you ping his server name? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-16 : 13:11:30
|
| DNS is not resolving the hostname to an IP address for you. I'd suggest contacting whoever is responsible for the DNS server to fix this. But an alternative is that you can setup an alias for the MSDE server using Client Network Utility or via regedit.exe. You can search the forums for my detailed explanation of how to do this if you need more assistance. Tara |
|
|
|
Help Desk
Starting Member
10 Posts |
Posted - 2005-06-23 : 15:18:28
|
| You could always add an entry to your hosts file so that the machine name always resolves to the same IP address. Are you part of a domain? If so, this shouldn't be happening.www.dotdesk.com Help Desk |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-23 : 15:20:15
|
| Modifying Hosts file is a thing of the past. For SQL Server connectivity, an alias is what you need. Being part of a domain doesn't help you when DNS isn't setup properly.Tara |
|
|
|
|
|
|
via IP and not servername why?