Problem:
* USB Harddrive or Pendrive is plugged in.
* Windows recognizes the USB mass-storage device.
* But, unable to access it using a drive-letter from Windows Explorer or Command Prompt.
Solution:
* Open "Disk Management MMC" - Start Run diskmgmt.msc.
* Add a drive letter.
That is it. You now see the drive letter in Windows Explorer.