If your optical drive is not showing up in Windows Explorer, please try the following tips to resolve the issue.
Eject The Tray
Try and eject the tray using the physical eject button located on the lower right of optical drive. If this fails, it would be an indication to you that the optical drive is not getting any power. You will then need to power down the computer using the OS or the power button then open the case and reconnect the power cable. If the tray opened during testing, then the data cable is the one that needs to be reconnected. Often, optical drive rest over hard disk drives so if the hard drive was upgraded or replaced, the cables may not have been put back correctly.
Switch the Cables
To see if the data cable went bad, switch it with the one connected to the hard disk drive after powering down the computer. If the Operating System loads when the data cable is switched, it indicates that the data cables are good and the issue is most likely a hardware related.
The SATA ports can be disabled so be sure to check the settings. SATA 0 is typically your boot drive while SATA 1 is the optical drive providing the system does not have multiple drives installed.