Connect via ip not name - why?

Hi

My colleague has set up MSDE on his machine. I am only able to connect
to his machine via IP and not servername

Why is this? I want to use ACCESS as a fornt end and can't useing IP
address

Jerry(jerry.osullivan@.esbi.ie) writes:
> My colleague has set up MSDE on his machine. I am only able to connect
> to his machine via IP and not servername
> Why is this? I want to use ACCESS as a fornt end and can't useing IP
> address

You can set up an alias for his machine in the Client Network Utility.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Sounds like a DNS issue; can you ping his machine using the machine
name? If not, try running ipconfig /flushdns from a command prompt and
pinging again. If that still doesn't work, you need to touch base with
your network administrator.

Stu