I have more or less the same issue. Upgraded my wife's PC with my older Motherboard, CPU and RAM, and added her HDD to that rig. Also added a brand new SSD. Bios does not detect the new drive or the old drive.
Strange thing is, the DVD ROM is detected when the exact same SATA port and cable is used. And why would the brand new SSD also not be detected at all?
Before testing the new SSD, I thought the HDD had failed. The first time I started, it seemed as though the Windows loading screen came up - now automatically booting from the HDD - but then a very quick blue screen led to a sudden restart of the computer. After that the motherboard did not want to detect ANY harddrive at all. But still, the DVD ROM is detected..
I still have to test the drives in another PC, but with BOTH not being detected, the chances of them being dead is really slim.
Please let me know if you have learned anything. Thanks