Your Windows XP CD and/or troubleshooting Cd (BartPE/WinPE?) Do not have the proper SATA controller drivers to recognize the user's SATA hard drive.
For WinXP installer, slipstream (eww, work) drivers onto a fresh burn, OR hit F6 at start of XP install to install SATA controller drivers (downloadable from mobo or PC support site) from FLOPPY DISK (only options in XP).
For Vista (eww new OS) you can BROWSE for drivers from HDD, CD, USB, or Floppy, but that won't help you for an XP repair.
For the BartPE/WinPE, your only option is to slipstream (turn a CD into an ISO, and modify the files on that ISO by editing .INI files and adding drivers, ADVANCED TECHIE TASK ONLY).
Rapebear Attacks! RAWR!