It's a cliché at this point, but giving your computer a reset really can help. If the CPU is under a lot of stress, or some other unknown hiccup occurs, it can prevent the drive from showing up.
I have this XP SP2 Pro machine which always exhibit this behavior. Whenever I connect any external USB drive or flash drives, the computer freezes for a few minutes and after a while it says that the ...