Need help with my Mainboard.

I dont know exacly when or how this happened but it seems like sata ports 4 and 5 out of the total 6 has stopped showing up its connected hdd's in windows even tho they are visible in the bios.

i have taken picture of my bios settings and bios post check at startup and the device manager inside windows, please help me.

These drives works perfecly if i plug them in using a usb hdd chassi so there's nothing wrong with the drives.

also, please help me to ensure i have the optimal bios settings configured as i dont fully understand them all and the manual doesn't help explain anything.

I am using windows 7 x64, latest updates and all. my motherboard is a Gigabyte, the modell and BIOS version is listed in the pictures i included, i have the latest bios from 1 year ago, beta.

i went to intels website and downloaded infinst911autol and installed it, now i got a bit different case in the device manager update screenshot after the installation, but it still didnt do anything.

I just bought a new hdd and plugged it in, when i booted up the computer did not activate any installation for new found harddrive and it doesn't show up in disk managment. I tried troubleshooting and it tried reinstalling but it didnt work, got some error message.

In the second bios post boot image why does the 2 IDE drives show up there with the new SATA drive and not with the other drives in the first post bios image? The IDE drives are working in windows as are 4 sata drives but not the other 2 sata drives for ports 4-5 on the mainboard. however they cant be broken since they show up in the bios, right?

The black&white picture i added, nr1 marked red, when i set that as AHCI and reboot, the computer never gets passed the second post bios screen, i have to reset the mainboard CMOS to even be able to do anything, i can't access bios settings.

The second marked in red, what does this do? and why do i have to activate this before i install windows, if i do after i get a BSOD as seen in the picture. Is this setting even important?

Edit - I can't read.

Did you try hitting the "Load optimized defaults" in the BIOS?

These hard drives used to show up on those ports before? Have you mixed and matched cables to eliminate the possibility of a faulty cable.