One of the reasons why this can happen is because the drivers that allow the CD-ROM drives to work in Windows XP have become corrupted.
The first thing to try is this Registry File. Remove the devices in Device Manager and reboot. The CD-ROM drives should work now.
If not, try these steps. Warning! These steps are not for the faint at heart.
Open the Device Manager and right-click on the CD-ROM drive that has a yellow exclamation mark by it.
Go to the Driver tab and click on the Driver Details button.
You should now have this window...
Look at each of the driver files that are being used for the CD-ROM drive, specifically the ones that aren't made by Microsoft. For instance, in the screen shot above is just one example of a device driver that isn't made by Microsoft. Copy all of the file names of the drivers that aren't made by Microsoft, you will need them for the next step.
Open up RegEdit and find all instances of those file names that you copied down in the last step. Delete any and all references that contain those file names.
Next, go into the Device Manager and delete the CD-ROM devices. Now, go to Add New Hardware and let it search for new devices. It should reload the CD-ROM devices minus the third-party device drivers, only the Microsoft supplied ones.
You should be good to go now! :-)
Feedback received on this FAQ entry: