I have my SSD connected to Sata 1, HDD to Sata 2, and my CD Drive to Sata 3.
Motherboard: MSI Z97 Gaming 3 Intel LGA1150 Z97 ATX
CD Drive: HL-DT-ST DVDRAM GH24NS90
Basically it works when it wants to. It'll read a cd fine, then it wont.
It disappears from the My Computer where you can see all your drives. It also likes to remove itself from the Device Manager, but when I click on Scan for Hardware changes it reappears.
When it's on the My Computer area, it appears under Devices with Removable Storage. It's almost as if it's going to sleep or something? I've tried updating the driver and it says it's up to date.