In the CD-ROM properties is says: Windows cannot load the device driver for this hardware. The driver may be corrupted or missing. (Code 39)
I tried with another CD-drive that I have and I still get the same issue...

EDIT: I seem to have narrowed it down....seems to be realted with iTunes. Whenever I uninstall iTunes my CD drive stops working. I'll try some solutions from the web...
*iTunes messed with the registry. I got it fixed.*