No versions of XP that I have (legit original, legit SP1, and... others) support loading SATA drivers off of a USB drive during an XP install.

So if you want to make the SATA the boot drive, you will need either a slipstreamed install disk or a floppy drive and disk.

If you want the SATA to be a secondary, then you just need to get the CD that came with your mobo and grab the drivers off of it (or download from manufacturer's website) while booted into windows, install, and reboot.

Also you can see what mode the SATA is on in the BIOS. Change to IDE if you can and still have the problems.