I'm having some server issues, hopefully someone might have some insight.
There is one server in my workplace which is set up strangely and I don't understand it. Every machine can ping/access/share with every other machine on the network except this one server. It is inaccessible except for an online website it hosts which can be found at (say):
help.company.com/webapp
However pinging help.company.com gets no response although the IP is resolved to (say) 192.168.9.108.
To access this server you have to Remote Desktop onto a different server (say: helpdepartment) and from that machine you can Remote Desktop to help.company.com (or just "help" which seems to be sufficient). So basically you have to go through 2 layers of Remote Desktop. From this machine other machines on the network are unreachable and it appears that it is the only computer on the network. I don't have much experience with networks so this confuses me (are they bridged or something?).
EDIT: Just realised that the weird server hosts a public website. Must be why it's segregated from the rest of the network. Security?
Anyway my problem is that I need to write an application which can connect to a MS SQL Server which is running on the weird "help" machine (the same database the internal website accesses - it's a bug tracking application). However any attempts at connecting are "refused". But it's refused not "host unknown" so there is definitely some interaction. Clearly this problem is linked with the strange setup described above (for all I know it's standard practice - I'm ignorant).
The firewall on the "help" machine is disabled. The ports are all configured to 1433 (default) on the MS SQL Server. I've been through about a million articles with various different fixes but nothing helped. The servers run Windows Server 2003 by the way.
So, anyone have any insight?
Thanks in advance; this has been driving me crazy. Carl