You have already determined that your Arduino Leonardo DOES NOT work. Since the USB interface isn't working ("Unknown USB device(Device Descriptor Request Failed)") I would expect either a bad connection or failed firmware. Try re-uploading the Leonardo firmware to see if that helps. You may want to spend the $4 or $5 to get a USBasp or USBtinyISP from eBay. They make firmware uploads much easier.