Connect via ip not name - why?

[jerry.osullivan@esbi.ie]

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

[Erland Sommarskog]

Re: Connect via ip not name - why?

(jerry.osulliva n@esbi.ie) writes:[color=blue]
> 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[/color]

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


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Stu]

Re: Connect via ip not name - why?

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