My ASUS board has two SATA ports. First, they must be enabled - then the driver must be installed by Windows. That comes on the CD that came with the mobo. On mine, the BIOS then runs right before Windows is loaded (FastTrack by Promise.) Normal boot/loading follows.
When it runs for the first time (reboot after it is installed) you get a menu which lets you set up RAID, etc.