@Mrinal charkraborty, The default tutorials are located at 127.0.0.1:8888 or use port 8000 to connect to the hue which is a useful interface I would recommend.
@David Bajus Try using the port 8000 in your web browser to find the user interface. Hortonworks is a CLI or command line interface. You will have to use a web browser.
@Michael Fluch and David Novogrodsky: if you do not want to use host-only on your virtual box you need to connect to your windows ip address with the appropirate port number. You can go diving into the virtual box settings under network and port forwarding, you can check the inet address using ifconfig in the CLI of Hortonworks sandobx, and you can gain access to the relavent port numbers and ip addresses in the command prompt by doing a netstat -n to look through them all.
@Somnath Chakrabarti: as stated above, you can connect through the windows ip address to the correct port to access which instance is open and talking with your host machine.
@Helge Sølvberg: I found the same issue when connecting sqoop to my oracle database doing testing on my laptop. Your able to connect to the IP address on the windows side (192.168.X.X:port#). For me I had to connect to 192.168.XX.XX:1521:XE instead of the local 127.0.0.1 ip address because it is not local to the virtual box.
I hope this information helps.