Now you will get all kinds of opinions, cable select settings, and different advice. Problem is, not all BIOS's for whatever reason will detect and work correctly using other settings, or it the drive is plugged into the wrong place on the ribbon.
To insure the drive WILL work....plug the drive into the end of the cable, set the jumper on the drive to master. If you hook up a second drive to the cable, put it in the middle, set it to slave.
Ensure that you have the ribbon cable plugged in the correct way. The side of the ribbon with red stripe is pin number "1". Make sure the red stripe corresponds with pin "1" on the board, and the drive if the cable has no notch to orientate it correctly. Some ribbons, believe or not do not have the notches on the plugs. The pins on the board and drive are marked right next to the plugs where pin "1" is.
Has no bearing on your SATA devices, your boot order in the BIOS can be set to boot from the IDE or your SATA device first, second, third, fourth, fifth and so on, or not at all, in your BIOS.
If you still get an error, the drive is likely failing.