The system standby, hibernate, turn off monitor features, sleep mode seem to cause a lot of headaches in XP.
You can try:
Hold down F8 while the system is starting up, click last known good configuration. If that does not work, try F8 again, click start windows normally.
Hope one of those two gets it out of sleep mode.