Hard Disk Boot Failure Insert System Disk

I formatted my hard drive today and after a reboot I got the message: "Hard Disk Boot Failure Insert System Disk And Press Enter" If I insert my Vista disk, hit f8 at startup and go to boot screen, click on boot from CD, then bypass the boot from CD option it will start Vista. I have checked my boot sequence and it shows booting from the right drive. My hard drives are SATA. Im stumped fellas......

Asus M2N-SLI Deluxe Motherboard
Two Hard drives but the second just for backup (not in RAID)




This is what my system information tool says on the hard drives:


Type Vendor Model Size Interface Temperature
Direct Access Device HDS72258 0VLSA80 SCSI Disk Device 82 GBytes IDE RAID
Direct Access Device Western Digital WDC WD16 00AAJS-60PSA SCSI Disk Device 160 GBytes IDE RAID
Direct Access Device SanDisk SanDisk U3 Cruzer Micro USB Device 1019 MBytes USB USB
DVD TSSTcorp SanDisk U3 Cruzer Micro USB Device USBSTOR RAID
DVD SanDisk TSSTcorp CDDVDW SH-S203N SCSI CdRom Device SCSI USB

UPDATE:


Changed my partition to active and re-booted, gave me this: "BOOTMGR missing"

Tried to repair with CD and the operating system was showing up on D:, dont know if this is usual but thought it show show C:

Went to Cromt in repair option and tried to rebuild bootmgr with this command:
"bootrec/rebuildbcd" restarted computer............BOOTMGR missing

Was then able to boot from second hard drive (D from boot screen.......finally gave up and formatted again......works fine now.