I have the same issue, thought the DVD was dead…was wrong.
Fortunately I have MS Server 2003 on a different partition and when I checked the DVD RW it works fine !
I am puzzled by this can’t give you a reason (been in IT for over 20 years). I have not really bothered with it as I have access through other machines but was bored one day and then ended up fed up
I have done usual drivers hardware checks etc but can say I am miffed.
It could be your issue is different and your drive is dead, try putting the drive into another PC and see whether it picks it up. Good luck