I had received a laptop while in the office that had a Yellow Exclamation next to the system DVD-ROM drive.
When looking at the properties of the drive the status read the following:
Windows cannot start this hardware device because its configuration information (in the registry) is incomplete or damaged.
I had found the following article on the Microsoft TechNet site with the following solution:
Remove/Delete the LowFilter and/or UpperFilter (you might have only one od these) entries from this registry area:
HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlClass{4D36E965-E325-11CE-BFC1-08002BE10318}
Note: You will have several identical keys like this {4D36E965-E325-11CE-BFC1-08002BE10318}. The one you are looking for will have DVD/CD Rom Drives as the top entry. Reboot after deleting the LowFilter and/or UpperFilter entries.
Once I had rebooted the laptop, this now worked 100%.