On my home network I have an installation of Windows Server 2008 and for some reason, the windows vista workstations on the network can connect to the server via remote desktop only via the server's IP address, not the hostname. Same for connecting to an instance of SQL Server 2008 that's on the server, only works by IP, not by hostname.
Yet, I have some file shares on the same server, and the workstations can see them just fine using the server's hostname.
The server/workstations are on the same private network, and have the same workgroup name.
Any idea why I can't seem to find the server via hostname in the situations outlined above?