Motherboard SATA issue

See if you can get your hands on another SATA device that you know is good that you can hook up to your board's SATA ports and see if the problem still occurs.

Although if you can, you may want to hook your SATA device up to another computer with SATA ports to see if it's the existing device that may be at fault.

One other thing you could also try if you have some lying around are different SATA cables. And you might want to make sure that the items are even getting power. One easy way of checking that is to plug the power cables into the ASUS drive in turn to see if the drive powers up and you can get the tray to open.

But if the drives are getting power, and they're still not being detected after trying different SATA cables then yeah, I'd try hooking those two devices up to another system with SATA ports. If that comp can see them and access them (at least in the case of the ASUS drive) then I'd say yeah, your MB SATA ports are most likely gone.

If that's the case then your only two options as far as I can see are to either get a SATA controller card or replace your MB. Final choice is yours of course though.