Restart your computer and enter the BIOS to see if the motherboard detects the CDROM at the hardware level.
I've run into a couple computers running Windows Vista where the CD/DVD drive wasn't recognized in Windows. The solution recommended here has worked for me in the past:
The CD drive or the DVD drive does not work as expected on a computer that you upgraded to Windows Vista