unable to connect sqlserver

[magi]

hi
i have a sql server running in sms server, and have sql enterprise manager in my work station. Trying to register the sql server to the enterprise manager in my workstation using the name of the server, it is saying unable to connect, but if use ip address its registering. why cant i register uing name of the server

thankx

 

[SQLBill]

It sounds like a DNS issue....try this:

Open a command tool (Start > Run, type cmd)
at the prompt type the following, but replace <ipaddress> with the actual IP Address:
ping -a <ipaddress>

The -a will resolve the address to the name if it can look it up. If it only returns the IP address and not a name then that is why you can't use the name.

One way to fix it, search on your computer for the hosts file. When you find it, open it using NOTEPAD (make sure you deselect the box - always use this for this type of file). Add the IP address and it's name to this file. Alternately, if you have a DNS server, make sure the IP address and name are on that.

-Bill