Formatting with the slave USB didn't work as the drive is not visible. I guess the player needs to see the drive first before making it visible through the slave USB port on the back.
I had to borrow a SATA-USB adapter to format the HDD and everything works now. Thanks.