I have installed WinXP SP3 and the BIOS is looking at the sata drives as IDE and not ACHI .
Is there any advice someone can give me about addressing this issue ?
You'll need to configure the drive controller to AHCI mode in the BIOS and SAVE changes out of there BEFORE attempting to install Win XP SP3. During the install you'll then need to go by the F6 Floppy Intsallation method (search the Intel site for details and read the readme files on the driver download page) or else you need to 'slipstream' these drivers into your Win XP Installation media. Newer Windows versions don't need this special treatment as the drivers are built in.
Not sure about the port details but have your read the motherboard manual to see what that says about things? Is it a B3 stepping board (not affected by the SATA bug)?