Important question: is this a brand new empty HDD? Or, does it already have a Partition that is Formatted, possibly containing data? The mobo certainly should be able to deal with a new empty SATA HDD as an AHCI device. However, if it was previously Partitioned as an emulated IDE device, the BIOS may have found that info on the HDD and cannot deal with it using AHCI techniques.
What you can do to overcome this depends a lot on what the unit contains.
1. If it is completely blank and new, there is something REALLY odd for the mobo to refuse to use it.
2. If it has been Partitioned and Formatted, but contains NO useful data to save, you can use Disk Management to Delete all its existing Partitions. You might have to put it into another machine and use it as an IDE-emulated device to do this, if your mobo refuses to recognize it. Once you have deleted its Partitions, shut down, reboot, and reset the BIOS to deal with it as an AHCI device, if it will.
3. If the BIOS still won't recognize it after "cleaning" per item 2, you may have to Zero Fill the drive to really wipe it clean, including the MBR. Then you can try it as an AHCI device and re-Partition it. Well, these days it's usually called Create a New Simple Volume.
4. Much more work if the HDD does contain data you need. In that case you probably will have to back up that data fully on some other device. Then you can really wipe the HDD clean (a Zero Fill is the most complete, but it does take a long time) and start fresh as if it were a brand new empty HDD unit.