Does the light stay on all the time or only when trying to read from the drive?
If it is on all the time, then you might have the cabel on backwards. Otherwise, you may just have a faulty drive.
Windows, only looks to see if the drive can be seen. It doens't test for function unless it tries to read from it.