Haven't made it to bed yet....
BTW in BIOS SATA Controllers say enhanced?
In your case: Enhanced = Enabled
Okay - swapped cables and optical works but SATA HD not recognised!
There is a choice of four SATA connectors on the motherboard, perhaps trying another might help.
They count from 1 to 4 starting at the bottom. In theory, the HDD is probably plugged into number 1, (the lowest), as it's reported as Primary IDE Master.
Try the SATA optical in port number 3, (second from the top), that should appear as Secondary IDE Master.
On your motherboard, the SATA ports are either all on or all off.
If it fails in the 3rd port, then try the other two - if they fail, you most likely have a bad cable.
Now I'm really going to bed.