Before you run off ...I boobed (it's not the first time and prolly won't be the last).
The Red LED on your board indicates a problem with your RAM not AGP (according to the Manual I just looked at anyway).
Most boards have a red led for what I said earlier, but not yours.