I was tearing my hair out too trying to get SATA to play nice with debian. In the end, downloaded a recent version of the netinst image.type in linux26 at boot to load the 2.6 kernel, then go to shell prompt and type in modprobe ata_piix, exit shell and voila it works!
Shem