Workstations cannot ping server yet can connect through Remote Desktop Connection

I have an application installed on a workstation that should be able to access server 2008 in order to read/write to a sql database. The program is also installed on the server and works fine. I am able to use remote desktop connection on the workstations to access the server and the program. I am also able to map a network drive on the workstation and access a particular folder on the server which the application requires to operate...yet every time I try to run the application from the workstation (as a program installed on the workstation), it hangs and must resort to ctl+alt+del to stop the program....I tried calling tech support and they said that they could not ping the server from the workstation and suggested that there might be an issue with dns??? but also said that it could be something else....Any advice would be greatly appreciated.

 

Make sure the mapped users have permission to read/write to the drive. If they are in read only there might be part of it.

As far as the server not responding to pings, you would have to enable that function on the server for it to have any meaning. There are a few ways to turn it on but this command should do it.
Go to a command prompt on the server and enter:

netsh firewall set icmpsetting 8

Test the ping again. If that didn't turn on the response, try the full windows procedure here

 

When we tried to ping the server, the firewall was turned off. Now that you mention the security permissions....I think I forgot to assign the security permissions to users. I will try that and see what happens. Thank you handygal.

 

Responding to ping function isn't related to the firewall. In order for a ping to come back to you, the server has to respond to the ping. It's not like radar that is going to come back if it hits something, the ping coming back is actively sent back by the remote system. The function for that is turned off by default in server 2008.

 

that's not totally accurate, it's more like the server purposely doesn't respond to the ping but it's not related to the firewall in this case.

Did your share permissions help the situation any?

 

What version of SQL are you using? I'm going to assume 2008, but it helps with most versions. Make sure that sql allows remote connections, make sure tcpip is on, and pipes are on.

Also, you may need to install the local sql native client on the client computers.

http://msdn.microsoft.com/en-us/library/ms131321.aspx

This will tell you if you have remote connections enabled.

 

I can't find the new thread button but do have a ping failure problem. I have four computers. Yesterday, two of them failed the ping test and they were laptops. Today they all failed the ping test yet I can get on the internet on all of them. I asked ChaCha and they suggested it it due to two computers using the same ip and one was bumped off. But right now there is only one laptop active and a desktop on standby. What could be the problem? Also, how do I start a new thread?