I had some trouble with the first two or three IDE-to-SATA adapters I had. Quite a few of them will require that the IDE drive be set to MASTER. I don't know if CABLE SELECT will cut it. In any case, there will likely be instructions with the adapter that state the proper setting.
As Bozo mentioned, MASTER/SLAVE/CS doesn't have much bearing the SATA world. It only comes up in this situation to get the adapter to work properly.
-SUO