If the CPU fan is running and one or more LEDs ar lit, then you are getting some power to the Mobo. However it does sound like you lost the Supply since the drives are not powering up. I would certainly replace the P/S first.I would go larger than what you probably have given the amount of stuff you are driving. 450 to 500 good quality.
Here's configuration:
Windox XP
AMD 2200
Asus MB A7V333 (I think)
1 Gig PC 2700 DDR
120 Gig WD HD (primary)
80 Gig IBM (secondary)
DVD rom (Primary)
DVR-R/DVD+R Burner
MSI GEforce MX400
For some reason or the other while I was using my PC last night, it automatically rebooted, my PC It started without a hitch. As I acess the Windows Explorer, it crashed and rebooted but this time, I did not see the systems check at all nor did I see the power LED go on. The system did not do a boot up sequence at all (did not check drives nor am I able to open the DVD drive) The CPU LED is the only thing running. The Chassis Fan and CPU fan are both running but nothing more. I suspect there is no power being channelled to my motherboard at all or maybe i have a bad memory.
Anyway, I appreciate any thoughts I can gather from this group.
Regards and thank you in advance
Noel

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic