AWOL.
If the drive/device isn’t listed in Device Manager, then that might point to why “no sound”.
Do you have any CD-R data discs (files, not music)? I assume those don’t display content either.
The drive may be getting power but the data lines may not be connected. If it isn’t too difficult, try removing the CD drive and reconnecting it.
Or before doing anything that would require disassembly, see if you can get MS to internally fix things. In Device Manager, go to Help and look up “Uninstall or Reinstall a Device”